Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Copied Pivot Tables with same data source

I have a report with 2 sections. Each section has about 6 tables. When I
created the first section, I created the pivots from scratch and based them
on the same data source to conserve on memory. Then I copied and pasted
these pivot tables into section 2, and then adjust the page fields. When I
did this, the memory amount surged so much that it slows everything down. Is
there a macro or something else that helps with this?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot tables - Editing the data source shared by multiple pivot ta sankat Excel Discussion (Misc queries) 1 April 22nd 10 03:05 PM
how to change old data source reference from copied pivot tables arun Excel Discussion (Misc queries) 1 May 20th 09 01:13 PM
How to change old data source reference from copied pivot table arun Excel Programming 1 May 20th 09 09:58 AM
Source Data in Pivot Tables cqc Excel Worksheet Functions 7 August 2nd 07 01:34 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM


All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"