changing link sources in excel 2010 files
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
|