I have links for ex. : =[file1.xlsx]Sheet1!J31 , I copy the Sheets from the external file to current file with the same name. How to remove automaticly all the "[file1.xlsx]" part from formulas?
I have links for ex. : =[file1.xlsx]Sheet1!J31 , I copy the Sheets from the external file to current file with the same name. How to remove automaticly all the "[file1.xlsx]" part from formulas?
Last edited by mitiozo; 01-18-2012 at 06:58 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks