Hi,

I've asked this a while back. I'm asking again because this is a huge failing in Excel, if true. I import a report, and then run my tools against it. My tools are on a sheet.

Sheet formulas do not travel.jpg

Why cant Excel understand that I'd like to use the same tools (the same sheet) on a new, similar report. But, no - I have to re-invent the wheel over and over because if I copy my sheet to a new workbook, the formulas do not travel with it - they keep pointing to the original source.

There has to be a way. I mean this is BASIC business practice. Surely, Excel didn't bungle this basic expectation for every business. I must be missing something.

Thank you.