refresh pivot tables

Morning All, I'm trying to avoid my dozens of pivot tables date groupings being lost in the event of a date being accidentally left blank in the source data. I've been toying around with the PivotTableBeforeAllocateChanges event but have had no joy, it just doesn't seem to work. As a test I...

HI , I have 5 pivot tables , 3 are connected on 1st raw data and other 2 are connected on 2nd raw data and I am trying to refresh them using both Excel refreshall button or Alt+f5 and I even tried macros(activeworkbook.refreshall) but It's not working for the first try , All I need to do is to...

Hi guys, I've Googled but I haven't been able to find any posts about my problem. I have imported data directly from a Teradata database and imported it as a "PivotTable Report" and not as "Table". The data is about 300,000 rows which is why I'd prefer not to import this as a "Table" as it...

Hi guys, on my excel file I create using a macro a data source as the result of an import (and merge) of two files. The data fills from cell A to Z in a sheet named "Master". This operation is done every week and. Due to some changes on the two files I need to import, the contents of the sheet...

Hi, I have a pivot table (Excel 2010) that compares two years financial data. Up to June it works fine but when I now refresh the data with July included many of the figures up to June also change to blanks. This is clearly incorrect. Can anyone help me with this? Thanks

I had a macro that was working fine, I tried to add one table and it broke. I then manually recorded a new macro of all the actions (thinking that would give me the proper code), but the code will still not work. the rerecorded code is 'refresh main pivot table...