Hi all,

This is my first post. I usually just read the other posts and find the answers but after scouring I can't seem to find the answer to my issue. So here goes:

I have a few master files which we use to create to data sets, within the files there are a variety of mapping tables we have created. Then the sheet which contains the templater refers to these mapping tables with vlookups.

When we open the document and re-save (to create a new iteration) the formulas seem to refer to the previous version of the document often. I'm not sure what we are doing wrong, as the tables and template are all in one document I don't know why it would continue to refer to the old version.

Any help would be much appreciated as it's causing us a nightmare...

Becky B