vlookup table array #ref error

Hi

This is probably a stupid question but ...

I have several dozen vlookup formula running off a spreadsheet (call it Sheet 4) that is sent in from another department.

If a new Sheet 4 is sent and saved in my folder over writing the old one, I will obviously get a ref error in my vlookup formulas .. but is there a way to avoid this. i don't particularily want to have to re-reference all my formulas for the new Sheet 4.

The format of Sheet 4 will be identical to the old one and my vlookup table array will be the same (Sheet4F:U)

regards

If the worksheet has the same name, I don't see why you'd get errors. Are the vlookup formulas in the same workbook as Sheet 4, or is it looking up Sheet 4 in a different file?

Hi Hoyasaxa

They are in different files!

I still don't see why you'd get errors. On the Data tab, you should be able to manage any connections and edit any links that give you errors. Replacing a file with an updated file that has the same name shouldn't be a problem.