Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I refresh a macro?
I have a pivot table that is connected to an excel page in which I can list
dollar amounts for an office code and the various office codes will be totalled on the pivot table. Now I can't get rid of last year's figures to make room for this year's amounts. How do I delete last year's amounts and post this year's amounts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I refresh a macro?
Try this...
Create a new copy of the spreadsheet so as not to loose last year's data. Delete last year's data from the source worksheet and paste in the current data. Use the Pivot Table Wizzard to make sure that all new data is in the range of the pivot table, then use the exclamation point on the pivot table toolbar to refresh the pivot table. Regards... "MVPMAILROOM" wrote: I have a pivot table that is connected to an excel page in which I can list dollar amounts for an office code and the various office codes will be totalled on the pivot table. Now I can't get rid of last year's figures to make room for this year's amounts. How do I delete last year's amounts and post this year's amounts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
link to combobox | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Editing a simple macro | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) |