Pivot table problems...
Posted by Dank on September 28, 2001 6:18 AM
Not sure if anyone can help me on this but I'll try anyway.
I have a pivot table where the datasource is a table in an Access database. The database stores monthly transactions extracted from our accounts ledger. The pivot table has months along the top and account numbers down the side. This worked fine until today with months 1 to 8 and a grand total shown along the top. However, today I've uploaded the first September numbers into the database. I went into the pivot table and clicked the refresh button expecting the new month to be added along the top but it wasn't (although the rest of the data refreshed because I checked by changing some August numbers).
Does anyone know how I can make the table include any new months without me having to recreate the pivot table each time or without using macros.
Thanks for any suggestions,