copy a formula from an other file without changing the adressing

Question

Hello, first sorry for my bad english&nbsp;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 paste the values. I usually keep one page with the formula, but I didn't this time.&nbsp;So I loose all my formula. I tried to find an old version of my file to copy the formula, but excell create link to the other workbook. That's not what I want, but he is smart isn't he?&nbsp;So my question is: is there anyway to copy the formula but ask excell not to keep the old reference but just to copy the formula letter by letter. I know that I can do this cell by cell, but this will be, really, really long...&nbsp;Thank you!

roraima07 · Answer

Olivier33&nbsp;I have run into a similar issue in the past.&nbsp; My solution was as follows:&nbsp;- 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.&nbsp; Be careful to note the EXACT syntax, else you will run into problems&nbsp;Hope this helps!&nbsp;

olivier33 · Answer

TxI 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.&nbsp;Thank you againroraima07&nbsp;

roraima07 · Answer

Olivier33&nbsp;Not to my knowledge.&nbsp;If you would like me to look into this matter further, you may send me an example of a formula copied from the old location and I can see if there is something else you should try.&nbsp;

Forum Discussion

copy a formula from an other file without changing the adressing

3 Replies

Resources