Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 358
Default Creating Pivot Tables

Hi,

Sometimes when I create a Pivot Table I want to use the same data I used in
other Pivot Tables. Excel is smart enough to know you already have other
Pivot Tables using the data and prompts you to select one to use.

I've noticed Excel adds 'Table1, Table2' etc to the name.

Can someone please explain why?

If you have tables ending with table1 or table2 does this means there is
more cache used?

Actually can you also please define cache for me in real layman terms
because I've read up on it a bit but still can grasp it.



--
Andrew
010208
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
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
Creating Pivot Tables using a CSV file Felippe Domingos Excel Discussion (Misc queries) 1 February 7th 07 10:33 PM
Help Please! - Creating Function Calculated Fields within Pivot Tables ColinS Excel Worksheet Functions 0 April 5th 06 11:19 AM
Creating a line graph from 2 pivot tables? gmodi Charts and Charting in Excel 3 March 7th 05 02:09 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 01:34 AM


All times are GMT +1. The time now is 06:51 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"