Excel database query

[mwolford]

I have a spreadsheet with separate tabs for 8 offices. Each tab then has a Excel database query set up to pull information from 8 files that the offices update monthly. A simple "refresh data" is all that should be necessary monthly to update the spreadsheet.

One tab is not working correctly. It continues to show the information from the previous month, even after a data refresh appears to have been completed. The file being extracted from is correct.

Any ideas?? I could really use some help.

 

[ETID]

If using MSquery, try deleting the faulty table and re-adding it.

 

[mwolford]

I haven't worked with queries much, other than to set them up and refresh data. How do I get to MSQuery to delete the faulty table and re-add it?

 

[ETID]

right click in the "returned data" area of the worksheet, then choose edit query.

when the query window opens, take note of the table name in the top pane (it should be the workahhet name where the data resides). then, delete the table, then from menu, table>add tables and choose the worksheet again. then drag the "*" down to the view data area (top left cell), then file, return data to excel.

if all goes smooth...then save the workbook,... otherwise bail out without saving.

 

[ETID]

Ooops,... thats "worksheet" not "workahhet"

 

[mwolford]

Well, frustration is setting in. I deleted the table, re-added the table, and the old numbers came back. Then I deleted the file that I was importing data from (so that those old numbers had to be gone. I went back into my main file, deleted the table, then deleted the old information from the tab, and closed the file.

I re-created the file to import from with the current months numbers, went back into my file and added a table from the new file (same name) and the old numbers came back.

My main question, I guess, is where could the old numbers be coming back from? Any thoughts?

 

[ETID]

2 wierd..let me study on that ...X-)