sorry for the dodgy title, didn't realise i hadn't finished (Should be "Formula Change on MS Query Refresh")
Hi,
I have just been given a windows 10 PC with Excel 2016 for testing.
I have a problem with a spread sheet that has been working for years.
in its simplest form:
A5:G100 containers a MS query table.
C1 = A5
As soon as A5 is refreshed C1 = #REF !
This hasn't happened before on previous excel versions so I assume its something to do with the way the data is cleared on refresh.
Is there quick fix? Hopeful of an error checking tickbox I can quickly change.
Thanks for your help.
Hi,
I have just been given a windows 10 PC with Excel 2016 for testing.
I have a problem with a spread sheet that has been working for years.
in its simplest form:
A5:G100 containers a MS query table.
C1 = A5
As soon as A5 is refreshed C1 = #REF !
This hasn't happened before on previous excel versions so I assume its something to do with the way the data is cleared on refresh.
Is there quick fix? Hopeful of an error checking tickbox I can quickly change.
Thanks for your help.
Last edited: