I have a problem in a collection of macros I am making in Excel. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
One macro is used to fill data into a spreadsheet. <o></o>
Other macros are used to, to deal with the above data, among other things, to form the PivotTable reports. <o></o>
The problem occurs when data is added to the source material.
The area used for the pivot table is named. If the named area is changed, the named range it will not be updated in the pivot table. <o></o>
Even if you try to create a new PivotTable report with the same name as sourcedata , is it the original range, which will be used-even if "Name Manager" shows the correct area.
Hope someone can help
Regards Annette
Details about code is here:
http://www.mrexcel.com/forum/showthread.php?t=531890
fficeffice" /><o></o>One macro is used to fill data into a spreadsheet. <o
></o>Other macros are used to, to deal with the above data, among other things, to form the PivotTable reports. <o
></o>The problem occurs when data is added to the source material.
The area used for the pivot table is named. If the named area is changed, the named range it will not be updated in the pivot table. <o
></o>Even if you try to create a new PivotTable report with the same name as sourcedata , is it the original range, which will be used-even if "Name Manager" shows the correct area.
Hope someone can help
Regards Annette
Details about code is here:
http://www.mrexcel.com/forum/showthread.php?t=531890
