(Msg. 1) Posted: Wed Feb 11, 2009 3:38 am
Post subject: Excel Pivot Table - Saving issue Archived from groups: microsoft>public>excel (more info?)
Hi, I have a file which contains several pivot tables, when I save the file
and reopen it for some reason it opens with all but one of the sheets as a
normal table as opposed to a pivot. Has anyone experienced this before/ has a
solution to my problem?
(Msg. 2) Posted: Wed Feb 11, 2009 8:51 am
Post subject: RE: Excel Pivot Table - Saving issue Archived from groups: per prev. post (more info?)
What version of Excel are you using, 2007? Are you really saying that the
pivot tables convert to Excel Tables? The structure and layout of these two
objects is entirely different. You can get a table from a pivot table by
double click the grand total cell but that table is on a different sheet.
Favorite Excel Time Saving Tips - Greetings. I just started working on a web page featuring favorite Excel time saving tips. Unfortunately, it is 9PM, I'm exhausted from watching football and playing with the grandkids and working on taxes. So, I can only think of a few. My..
Changing pivot datasource by formulas? - Hi guys :) I not quite sure if there is any solution to this. My last chance is to cry for help in this room of qualifications... (aaaargh!!) This monthly "cut-off" report of mine is based on one chosen dataset (the last monthly) - placed in ...
calculate percent of a col in pivot report - Hi, I have a pivot report based on a query against a database. The query has 3 columns Gender, CntMale, CntFemale In the pivot report, I need to show the percent of Male, for which I believe I need to have the column display the value in the CntMale....
Excel 2003 toolbars in Excel 2007 - I have used Excel 2003 for years and have made a rather heavy customization by defining new toolbars with buttons calling VBA. Unfortunately, with Excel 2007 toolbars no longer exist! Gates and his gang of developers have decided that we all have to..
Unable to open excel 2007 file in excel 2002 despite havin.. - Hi I have installed office compatibility pack for office 2007. However, every time I try to open an xlsx file, I get unrecognized format error in Excel 2002. I can open docx without an issue. It appears to be that the problem is related specifically....
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
