I get a not enough memory error when loading a file which links to other files using HLOOKUP and MATCH formulas.
The cells containing the links end up with #NA in them until I open the linked files.
I also get a not enough memory error when I try and save said file. After clicking OK I get a message 'Unable to save external link values'.
Having said this everything does seem to work as I expect, its just a bit disconcerting and inconvenient for other users.
Any ideas what is happening and how to stop it would be gratefully received.
The cells containing the links end up with #NA in them until I open the linked files.
I also get a not enough memory error when I try and save said file. After clicking OK I get a message 'Unable to save external link values'.
Having said this everything does seem to work as I expect, its just a bit disconcerting and inconvenient for other users.
Any ideas what is happening and how to stop it would be gratefully received.