When you copied the sheet it kept the reference to the other sheet in the formulas like this;
[Budget.xls]Annual! refers to another file and sheet. You will need to remove these references to leave only the formula
You can use Find and Replace to remove them.
Note: Backup your work. Use at your own risk. Not responsible for lost data.
- On the Edit menu, click Replace.
- In the
Find what box, type refrence to the other sheet,
[Budget.xls]Annual!, and leave the
Look in box empty.
Options choose to
Look in formulas.
- Click Replace All.