Renaming a file that is referenced in another speadsheet
I have two worksbooks that I use at work which cross reference each other in numerous formulas. I was wondering is there was a good way to rename one of these files and have the formulas in the other self update. I could do a find and replace, but I'm assuming there's a better way. Any help here?
Thanks in advance.
Cheers
Open both workbooks, then do a SAVEAS on them to get the new filenames active in the opposing workbooks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I only need to change the name of one file. Can I just do a SAVE AS on the one? Do I just delete the old file when I'm done?
If you want to delete it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks