URGENT: spreadsheet not updating once I've change the Access query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet which is connected to an Access Query.
I have change the query in Access because I was not using the proper field.
Now, my spreadsheet doesn't want to refresh. It says that it's missing a
field.
How can I reconnect them ?
I've try to use the wizard, but when I get to the "Get Data" button, it
freeze.

I have about 10 spreadsheet with pivot table/graphs with complex filters. I
don't want to redo it all just because I change one single field....

thanks
 
ok, fixed the problem. I had to reboot. Now, I can access the data provider.

But it has lost all the fields, I have to reimport them one by one and
reapply the filters... that's a pain....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Count query 1
Spreadsheet import/update to normalised database. 4
Update Query using Excel data as input 8
Import Many Tabs from Many Spreadsheets 1
Update Query from Access 2003 Linked Table 1
Calculate Totals in Spreadsheet 2
Change default export to Excel location - Access 2007 5
my query does not update table 2

Back
Top