A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I save Pivot Table Data



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 02:33 PM posted to microsoft.public.excel.misc
webeinky
external usenet poster
 
Posts: 9
Default How do I save Pivot Table Data

Hello,

I have created a Pivot Table in a Excel 2007 Template which uses the data
from an Access 2007 table. In my Connection Properties I have all the
"Refresh Controls" unchecked.

Every month the Access table is updated with new data. We want to keep a
snap shot of the data for each month.

Is there an easy way to save the Pivot Table where it keeps the data but not
the connection so it can't accidently be "refreshed" AND it can still be
used/viewed as a Pivot Table? The people who will be saving this are not
experienced Excel Users.

I have tried to Save As it as the various Excel formats but they all seem to
allow refresh.


--
Nancy
  #2  
Old June 3rd, 2010, 02:46 PM posted to microsoft.public.excel.misc
steve
external usenet poster
 
Posts: 28
Default How do I save Pivot Table Data

A bit out of my comfort zone here, but couldn't you select the pivot table,
and then do copy and then paste values. It works if you want to stop
formulas updating and just need the results as a record.


"webeinky" wrote in message
...
Hello,

I have created a Pivot Table in a Excel 2007 Template which uses the data
from an Access 2007 table. In my Connection Properties I have all the
"Refresh Controls" unchecked.

Every month the Access table is updated with new data. We want to keep a
snap shot of the data for each month.

Is there an easy way to save the Pivot Table where it keeps the data but
not
the connection so it can't accidently be "refreshed" AND it can still be
used/viewed as a Pivot Table? The people who will be saving this are not
experienced Excel Users.

I have tried to Save As it as the various Excel formats but they all seem
to
allow refresh.


--
Nancy



  #3  
Old June 3rd, 2010, 03:37 PM posted to microsoft.public.excel.misc
webeinky
external usenet poster
 
Posts: 9
Default How do I save Pivot Table Data

Steve,

Thank you for your speedy reply.

I have tried that, the problem with it is you loose the formatting as a
pivot table and the ablility to easily change what you are viewing such as
moving around your Row Labels to change how you are veiwng the data.


--
Nancy


"steve" wrote:

A bit out of my comfort zone here, but couldn't you select the pivot table,
and then do copy and then paste values. It works if you want to stop
formulas updating and just need the results as a record.


"webeinky" wrote in message
...
Hello,

I have created a Pivot Table in a Excel 2007 Template which uses the data
from an Access 2007 table. In my Connection Properties I have all the
"Refresh Controls" unchecked.

Every month the Access table is updated with new data. We want to keep a
snap shot of the data for each month.

Is there an easy way to save the Pivot Table where it keeps the data but
not
the connection so it can't accidently be "refreshed" AND it can still be
used/viewed as a Pivot Table? The people who will be saving this are not
experienced Excel Users.

I have tried to Save As it as the various Excel formats but they all seem
to
allow refresh.


--
Nancy



.

  #4  
Old June 3rd, 2010, 03:47 PM posted to microsoft.public.excel.misc
steve
external usenet poster
 
Posts: 28
Default How do I save Pivot Table Data

Ok, Just a thought, couldn't you create a copy of your "data table" and
copy/paste values of that to a Library sheet, and then create your Pivot
table from that static data.

Regards
Steve



"webeinky" wrote in message
...
Steve,

Thank you for your speedy reply.

I have tried that, the problem with it is you loose the formatting as a
pivot table and the ablility to easily change what you are viewing such as
moving around your Row Labels to change how you are veiwng the data.


--
Nancy


"steve" wrote:

A bit out of my comfort zone here, but couldn't you select the pivot
table,
and then do copy and then paste values. It works if you want to stop
formulas updating and just need the results as a record.


"webeinky" wrote in message
...
Hello,

I have created a Pivot Table in a Excel 2007 Template which uses the
data
from an Access 2007 table. In my Connection Properties I have all the
"Refresh Controls" unchecked.

Every month the Access table is updated with new data. We want to keep
a
snap shot of the data for each month.

Is there an easy way to save the Pivot Table where it keeps the data
but
not
the connection so it can't accidently be "refreshed" AND it can still
be
used/viewed as a Pivot Table? The people who will be saving this are
not
experienced Excel Users.

I have tried to Save As it as the various Excel formats but they all
seem
to
allow refresh.


--
Nancy



.



  #5  
Old June 3rd, 2010, 04:44 PM posted to microsoft.public.excel.misc
webeinky
external usenet poster
 
Posts: 9
Default How do I save Pivot Table Data

Steve,

Thanks for another good idea. I was trying to avoid that, if possible, each
month have over 75,000 records that would need to be saved.

--
Nancy


"steve" wrote:

Ok, Just a thought, couldn't you create a copy of your "data table" and
copy/paste values of that to a Library sheet, and then create your Pivot
table from that static data.

Regards
Steve



"webeinky" wrote in message
...
Steve,

Thank you for your speedy reply.

I have tried that, the problem with it is you loose the formatting as a
pivot table and the ablility to easily change what you are viewing such as
moving around your Row Labels to change how you are veiwng the data.


--
Nancy


"steve" wrote:

A bit out of my comfort zone here, but couldn't you select the pivot
table,
and then do copy and then paste values. It works if you want to stop
formulas updating and just need the results as a record.


"webeinky" wrote in message
...
Hello,

I have created a Pivot Table in a Excel 2007 Template which uses the
data
from an Access 2007 table. In my Connection Properties I have all the
"Refresh Controls" unchecked.

Every month the Access table is updated with new data. We want to keep
a
snap shot of the data for each month.

Is there an easy way to save the Pivot Table where it keeps the data
but
not
the connection so it can't accidently be "refreshed" AND it can still
be
used/viewed as a Pivot Table? The people who will be saving this are
not
experienced Excel Users.

I have tried to Save As it as the various Excel formats but they all
seem
to
allow refresh.


--
Nancy


.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:21 PM.


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