If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Imported Datasource seems to be caching - need to pull updated dat
In Excel I imported data from the Oracle db specifically Toad. This datasource gets updated on a daily basis and I need to pull in the latest data each day in Excel. Unfortunately as I refresh the data I noticed that it's still showing the old data. So I deleted the database connection and reestablished a new one in a new Excel spreadsheet and still I get the same results. More interestingly, at times when I try to edit the query via EDIT QUERY the system would not show the database connection created. Makes you wonder where it's pulling the data from and how we can clear out that data?
I appreciate any help I can get on this. Thanks. |
#2
|
|||
|
|||
Imported Datasource seems to be caching - need to pull updated dat
Hi,
Are your settings correct? right click on the first cell and select "Data Range Properties.." on this box, make sure "refresh data on file open" is checked. jeff -----Original Message----- In Excel I imported data from the Oracle db specifically Toad. This datasource gets updated on a daily basis and I need to pull in the latest data each day in Excel. Unfortunately as I refresh the data I noticed that it's still showing the old data. So I deleted the database connection and reestablished a new one in a new Excel spreadsheet and still I get the same results. More interestingly, at times when I try to edit the query via EDIT QUERY the system would not show the database connection created. Makes you wonder where it's pulling the data from and how we can clear out that data? I appreciate any help I can get on this. Thanks. . |
Thread Tools | |
Display Modes | |
|
|