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?