Hi there,
I'm using excel 2016and have three macro-enabled worksheets that have links to each other, The files are not that big, 7mb the biggest and have been created and sent from another source, though in the latest excel version.
The worksheets can be unstable for some reason particularly on our network and they lose the link to each other and you get the #REF! statement in the linked cells. I've got into Edit links option when prompted and can see if the worksheets are available.
I don't know if it is the way I'm opening them or I need to do something elsewhere under options, I don't really know and would appreciate any ideas, corrective measures?
Regards
Ben
I'm using excel 2016and have three macro-enabled worksheets that have links to each other, The files are not that big, 7mb the biggest and have been created and sent from another source, though in the latest excel version.
The worksheets can be unstable for some reason particularly on our network and they lose the link to each other and you get the #REF! statement in the linked cells. I've got into Edit links option when prompted and can see if the worksheets are available.
I don't know if it is the way I'm opening them or I need to do something elsewhere under options, I don't really know and would appreciate any ideas, corrective measures?
Regards
Ben