Saved Copies of Workbook Reference Original

This should be an easy solution but I couldn't find anything. I use a workbook and save a copy daily. Lately when I've been saving a copy (via save as) all my formulas change and reference the original document.

For example, when I save all my formulas change to something like this:
=VLOOKUP(B14,'C:\Documents and Settings\matt\My Documents\\[originalworkbook]sheet'!$AD:$AE,2,0)

I do not want this. I want all my formulas to reference the active workbook. How do I change this?

Hi Matt,

My guess would be that at some stage, a copy of formulas has been made between the workbooks. This has resulted in Excel creating a LINK to the Original Workbook.

Have a look at the Data Ribbon, and Under Connections, click on Edit Links.

Try clicking on Break Links.

If that doesn't work, try Change Source, and select the current workbook.

I hope this helps, please let me know!

Regards,

David

When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".