I have a sheet with many formulas. I am trying to copy them into a new workbook however the formulas reference the previous workbook.

How can I replace the previous workbook reference in these formulas?

I have tried find and replace, Find What: '[workbook v1.1.xlsm] ReplaceWith : "" , i've also tried just leaving this field blank.

I get the following error:

"We found a problem with the following formula"

Does anyone know how to fix this? Thanks.

  • You can use Find and Replac- Options>> - Look in: Formulas- change the data in Formula you want. – Lee Dec 24 '18 at 7:24

Looks like I was able to to go Data -> Edit Links -> Then choose the current workbook from the file picker. It got rid of all other workbook references I had.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.