A colleague of mine has provided me with a spreadsheet [small 3 tabs each tab no more than 250 rows and columns to Q].
It is a spreadsheet that is prepared each month based upon the data in the prior month sheet. It has been being used for may 5 years now.
It had links to the prior month file and then the prior month file and so on. This seems to be a problem with Excel if too many files are linked in this manner. I have experienced it with much larger files and have now changed the way i prepare the files.
This little file however does not want to play at all.
I now have the file not linking to the prior month file but the prior month data [values only] in a separate tab and that is interrogated using a Vlookup formula.
I have deleted all the rows and columns beyond the necessary data to ensure there is no erroneous data elsewhere in the spreadsheet.
I have checked all the formulae to make sue there is not link to an external file.
I have not copied the file to a thumb drive and opened it on another PC and the issue continues.
I am not an IT person nor a wizard at Excel but what could i be missing.
Any assistance or direction would be wonderful.