Forum Discussion
copy a formula from an other file without changing the adressing
Hello, first sorry for my bad english So I have a big excell workbook with many formula that I use to generate different sheet. Before I give the final document to the people that need it, I copy...
Olivier33 I have run into a similar issue in the past. My solution was as follows:
- look at the syntax of one of the formulae--it usually has the name of the original workbook, complete with the folder path, embedded in it
- select all the cells in the entire worksheet
- replace the name of the original workbook with nothing. Be careful to note the EXACT syntax, else you will run into problems
Hope this helps!
Tx
I tried something like that but it didn't go well... I should probably try again. I was wondering if there was some way to say to excell: please copy all the formula on this sheet without changing the adressing, but maybe it doesn't exist.
Thank you again