B
baracuda9
Hi,
I have an Excel spreadsheet into which I pull data from Access qurie
using the "Get External Data -> New DB Query" option. I have severa
worksheets each pulling data via it's own Excel Query. This works fin
when setting it up - problem starts when i try and "Refresh Data
sometimes the link is just gone, and there is no query anymore?
Sometimes, the refresh option is there, I click it, it htinks, pulls i
the latest data, and then just self destructs - i.e. the query is gone
and you cannot refresh anymore. Only thing I know to do is to rebukl
the whole query from Excel again!
Does ANYONE know how to solve this issue???
Thanks
I have an Excel spreadsheet into which I pull data from Access qurie
using the "Get External Data -> New DB Query" option. I have severa
worksheets each pulling data via it's own Excel Query. This works fin
when setting it up - problem starts when i try and "Refresh Data
sometimes the link is just gone, and there is no query anymore?
Sometimes, the refresh option is there, I click it, it htinks, pulls i
the latest data, and then just self destructs - i.e. the query is gone
and you cannot refresh anymore. Only thing I know to do is to rebukl
the whole query from Excel again!
Does ANYONE know how to solve this issue???
Thanks