changing link sources in excel-2010 files

mhagi · #3 01-31-2017, 01:45 AM

Hi Kev,

thought, I'd mentioned that already.

Is this something that will happen again in 12 months?

Yes. Probably will happen again next year, and the year after and ..... and.
And I already tried to get the department to neutralize their file names etc.
But they are accountants!! You know, these people who need to have facts written down, spelled, sung, danced and ratified by congress (no insult intended. They pay my check. But Facts are Facts! lololol). They decide on a name, that’s it!

How many worksheet names have changed?

Which worksheets are you asking after? Links need to be changed in 94 files. Each file has about 14 sheets. Most sheets have formulas with linked informations.
Basic files (those the links refer to and I wish to change) are 3 to 5.

3) What are the old worksheet names? What are their equivalent new names

Example:
old name of file: workdays2016 – old sheet Name: 2016
new file-Name: workdays2017 - new sheet Name: 2017

Any suggestions other than modifying each formula?

Thanks in advance

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Batch create word files with link to changing excel	hannes.ledegen	Mail Merge	8	04-07-2016 01:22 AM
Excel Office 2010 Files will not open outside of excel	stevetag	Office	3	06-22-2014 07:23 PM
Changing/ updating LINK from power point & excel	johnseito	PowerPoint	0	01-28-2014 06:31 PM
Excel 2010 changing external link formulas automatically on Webdav mapped drive	dirkswart	Excel	2	10-07-2013 12:44 PM
PPT 2010 will only insert, not link to audio files.	kevin3d	PowerPoint	1	10-07-2011 09:17 PM