[SOLVED] Replace links from external files sheets to current file sheets?

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?

As long as the sheet names are the same in your source and destination files, then 'search and replace' should do it - search on the file name [file1.xlsx] and replace with nothing. You will probably need to have the source file open as well as the destination though, or you could get an error.

LOL Thank you very much. So simple. I did not know that search is "looking" into the formulas.
Regards