Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 23rd 05, 04:18 PM
dipsy
 
Posts: n/a
Default Pivot Tables - Named Range

Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.

  #2   Report Post  
Old August 23rd 05, 04:21 PM
db
 
Posts: n/a
Default

Go to Data-Pivot Table and PivotChart Report.... and select the back button
to change the reference.
--
Regards,
db


"dipsy" wrote:

Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.

  #3   Report Post  
Old August 23rd 05, 04:25 PM
db
 
Posts: n/a
Default

Sorry... forgot to mention one thing, make sure you click on the pivot table
you want to change first!

--
Regards,
db


"db" wrote:

Go to Data-Pivot Table and PivotChart Report.... and select the back button
to change the reference.
--
Regards,
db


"dipsy" wrote:

Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.

  #4   Report Post  
Old August 23rd 05, 04:30 PM
dipsy
 
Posts: n/a
Default

Hi DB:

Thanks for the suggestion - however, when u go back and change reference you
loose the set up of the pivot table. I want to keep the set up and change
the source for the named range of the pivot table.

Thanks.

"db" wrote:

Go to Data-Pivot Table and PivotChart Report.... and select the back button
to change the reference.
--
Regards,
db


"dipsy" wrote:

Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.

  #5   Report Post  
Old August 23rd 05, 04:45 PM
db
 
Posts: n/a
Default

dipsy -
Can you go into more detail when you say 'you loose the set up of the pivot
table'? Changing the reference of the pivot table should just update the
numbers in your existing table, as long as the format of the new sheet
matches your old.

--
Regards,
db


"dipsy" wrote:

Hi DB:

Thanks for the suggestion - however, when u go back and change reference you
loose the set up of the pivot table. I want to keep the set up and change
the source for the named range of the pivot table.

Thanks.

"db" wrote:

Go to Data-Pivot Table and PivotChart Report.... and select the back button
to change the reference.
--
Regards,
db


"dipsy" wrote:

Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.



  #6   Report Post  
Old August 23rd 05, 04:50 PM
dipsy
 
Posts: n/a
Default

Hi DB:

That makes sense - the format of the new sheet does not match the old sheet
- hence the issue. When I just changed the reference - the whole layout was
lost.

Thanks,
Deepali



"db" wrote:

dipsy -
Can you go into more detail when you say 'you loose the set up of the pivot
table'? Changing the reference of the pivot table should just update the
numbers in your existing table, as long as the format of the new sheet
matches your old.

--
Regards,
db


"dipsy" wrote:

Hi DB:

Thanks for the suggestion - however, when u go back and change reference you
loose the set up of the pivot table. I want to keep the set up and change
the source for the named range of the pivot table.

Thanks.

"db" wrote:

Go to Data-Pivot Table and PivotChart Report.... and select the back button
to change the reference.
--
Regards,
db


"dipsy" wrote:

Can some one help me change the data source on the Named Range for the Pivot
Table.

For example - the named range refers to Sheet 1. Change the named range to
refer to Sheet 2.

Thanks.



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
Match function...random search? Les Excel Worksheet Functions 10 July 28th 05 11:54 AM
How do I edit a Named Range using macro's behmer Excel Worksheet Functions 2 July 26th 05 09:02 PM
Pivot Table - max rows allowed in data range dmotika Excel Discussion (Misc queries) 2 May 26th 05 05:52 PM
Combining Pivot Tables - Summarising data from 100,000 rows Alan Excel Discussion (Misc queries) 1 May 18th 05 10: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 12:32 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017