Excel - UpdateLinks := causing syntax error
Hi Possible silly question time. I have several spreadsheets which contain links to cells in other spreadsheets. I need these links to be updated while a test is running, however whenever i o...
Forum Discussion
From a dim and distant memory, I'm sure there is an option setting somewhere in Excel which determines whether it tries to automatically update things like this when you open a sheet?
I'm wondering if that may be part of the problem. If you set it to ignore notifications before opening the file, does this still happen?
*EDIT*
Update. Sorry. I just re-read it. I think it's that setting you're trying to trigger on opening the sheet.
I've never tried to do this. Is it a setting (such as visibility and notifications) that you set before opening the sheet?
