Hi

i have 1 Excel file with a pivot table called PVT. It is reading data
from another Excel file which i called Excel_DB. This Excel_DB file
will get overwritten with data from Oracle DB using a data retrieval
tool which can export data into excel file format.

The strange think is, i do not know what indicators are stored in the
original Excel_DB used to create the PVT. Reason :

1) if i export data into another excel file, copy and paste the data
into Excel_DB, i can refresh data in PVT w/o having to open the file
Excel_DB at all.

2) if i use the tool to overwrite Excel_DB, then when i try to refresh,
it gives the "The pivottable field name is not valid" error messge.

3) But if i open Excel_DB at the same time, the refresh works.

As such, i do not know what is wrong with the overwritten excel_DB file
in the "unopen" state.

It is a problem as i do not want user to open the Excel_DB file each
time they want to refresh the data. All i want them to see is PVT only
which data autorefresh everytime.

for your help please
Thank you in advance
Boon Yiang