ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   The pivottable field name is not valid (https://www.excelbanter.com/excel-discussion-misc-queries/116777-pivottable-field-name-not-valid.html)

[email protected]

The pivottable field name is not valid
 
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



All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com