I need some help. I have a series of files with links to other supporting files. If I have both of the linked files open values are updated with out any errors. If I open the primary file and leave the secondary files closed I get the #value! error in all of the linked cells. If I then open the secondary file the correct values are displayed.
Any help would be appreciated.
Thanks
Any help would be appreciated.
Thanks