Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table refresh problem
I have a source data sheet, and a pivot table report which pulls from the
data sheet. The report also has some calculated field in it. When I "refresh" my report after changing or adding data in the data source, the report deletes the columns being pulled from the data sheet, puts #NAME? in all the calculated field columns and give me a message " do you want to replace the contents of the destination cells.. yes or no". Clicking either yes or not does not restore the columns. I'm using Excel 2003. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table refresh problem
So what's the question?
-- If this helps, please click the Yes button. Cheers, Shane Devenshire "mindyg" wrote: I have a source data sheet, and a pivot table report which pulls from the data sheet. The report also has some calculated field in it. When I "refresh" my report after changing or adding data in the data source, the report deletes the columns being pulled from the data sheet, puts #NAME? in all the calculated field columns and give me a message " do you want to replace the contents of the destination cells.. yes or no". Clicking either yes or not does not restore the columns. I'm using Excel 2003. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table refresh problem
It sounds like the items used as column headings in the source data have
changed. When you refresh the pivot table, it tries to add all the new items as headings. For example, in the source data you might have had Jan and Feb in a column with the heading "Month". Then, in the latest data, Mar, Apr and May were added. In the pivot table, you have Months in the Column area. Now, when you refresh the pivot, there are 5 month names, instead of the previous 2. If there's anything in the column to the right of the pivot table, there won't be room for the new months, and you'll see the warning. Insert some blank columns, and it might work correctly. For the calculated field, did you change any of the column headings in the source data? If so, the calculated field won't automatically recognize the new heading, so you'll have to change the formula. mindyg wrote: I have a source data sheet, and a pivot table report which pulls from the data sheet. The report also has some calculated field in it. When I "refresh" my report after changing or adding data in the data source, the report deletes the columns being pulled from the data sheet, puts #NAME? in all the calculated field columns and give me a message " do you want to replace the contents of the destination cells.. yes or no". Clicking either yes or not does not restore the columns. I'm using Excel 2003. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Pivot Table Refresh | Excel Worksheet Functions | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Pivot Table Refresh Problem | Excel Worksheet Functions | |||
Pivot table Refresh problem | Excel Discussion (Misc queries) |