Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
×

Removing internal links

More
4 months 2 weeks ago #1262 by Jay Chivo

Please Log in or Create an account to join the conversation.

  • Al Middleton
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
More
4 months 3 weeks ago #1251 by Al Middleton
Removing internal links was created by Al Middleton
Many moons ago (excel 2003, I think), I worked for a public accounting firm. We had an addin that basically removed internal links, similar to the break links function. If you have set of worksheets that lead to a consolidated page -- one is the data, and the others generally pull from the data to present the financials. If that data source is in an external workbook -- you would just break links, and values would be in place of the last updated link value in the cells. The on-page formulas -- not referencing other outside workbooks would still remain.

I have financial statements that refer to other worksheets (in the same workbook) for their data. I want the column functions, and computations that exist without a reference to another tab to remain, while I want the values that come from another tab to be just values. Currently, I copy/paste values inside each table, but it is very tedious -- something that would love for a snazzy tool to be created. Does Kutools do something like that?

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo