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,
"" , 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.