Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Excel 2004 and pivot tables

  
   Macintosh computer (Home) -> Excel RSS
Related Topics:
Does Excel 2004 have Pivot Tables? - I know Excel X does not have Pivot Tables. Looking for a reason to = to Office 2004. Anyone know if Excel 2004 has Pivot Tables? Thanks!

creating pivot tables excel 2004 for mac - Hi, Why in excel 2004 for mac when i create a pivot table doesn't show data, i checked all options and data source but that look good and also when i open a workbook that have a pivot table generated in a pc it look nice but if a hide only one field..

Excel with SP2 corrupts worksheets with pivot tables - We have a worksheet on our server that was created with Excel 2004 11.1.0. It is opened and used by several 11.1.0 users, but sharing has not been It is set to save an file every ten minutes plus it is set to save a..

PIVOT DATA TABLES EXCEL 2004 VS EXCEL 2003 FOR WINDOWS - JIM the problems seems to be the syntax. When opened in my MAC all I get is #VALUE!. Hoever, when opened in Windows, it opens I really need to make it work because I am pulling a great deal of date from the dynamic tables to..

Excel 2004 Pivot table will not total rows - The box for Row Totals in the pivot table options is checked. The pivot table will not total the rows. else including column totals seems to work fine. I tried reducing the amount of data in the pivot table to a smaller
Next:  Excel: Office 2004 Test Drive Available  
Author Message
Chris Waskowich

External


Since: May 19, 2004
Posts: 3



(Msg. 1) Posted: Wed May 19, 2004 11:08 am
Post subject: Excel 2004 and pivot tables
Archived from groups: microsoft>public>mac>office>excel (more info?)
I have a workbook that I frequently update - about 3 times a week. The
primary page in it is a worksheet with a pivot table. I update the
contents of the other worksheets in the workbook and then update the
data-range of the pivot table. This all works just fine and
sufficiently in v.X, however, in 2004, when I get into the Wizard and
hit the 'Back' button to change the range, Excel crashes. It is highly
repeatable and seems to do it on any workbook with a pivot table.

Can anyone else verify this? Or, does anyone have a clue as to why
this is happening?

I have to re-create the pivot table *every* time I want to update the
data... which really puts a damper on progress. Also, just as a short
term fix, could I have a VB script or (forgive me for saying this) a
Macro which can update the range of the Pivot table?

 >> Stay informed about: Excel 2004 and pivot tables 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 2) Posted: Wed May 19, 2004 2:09 pm
Post subject: Re: Excel 2004 and pivot tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <2004051908083916396%cwasko@NOmacSPANcom>,
Chris Waskowich <cwasko.TakeThisOut@NO-mac-SPAN.com> wrote:

 > I have a workbook that I frequently update - about 3 times a week. The
 > primary page in it is a worksheet with a pivot table. I update the
 > contents of the other worksheets in the workbook and then update the
 > data-range of the pivot table. This all works just fine and
 > sufficiently in v.X, however, in 2004, when I get into the Wizard and
 > hit the 'Back' button to change the range, Excel crashes. It is highly
 > repeatable and seems to do it on any workbook with a pivot table.
 >
 > Can anyone else verify this? Or, does anyone have a clue as to why
 > this is happening?
 >
 > I have to re-create the pivot table *every* time I want to update the
 > data... which really puts a damper on progress. Also, just as a short
 > term fix, could I have a VB script or (forgive me for saying this) a
 > Macro which can update the range of the Pivot table?

I can't reproduce this with any files with PTs. Does it happen with a
fresh workbook?

If you're just changing the range, you may be interested in using
dynamic ranges instead:

<a style='text-decoration: underline;' href="http://www.contextures.com/xlPivot01.html" target="_blank">http://www.contextures.com/xlPivot01.html</a>

As for a macro (which is just a script written in VBA, so I'm not sure
what you have against them), start by recording a macro while you
generate your PT. For more help, Jon Peltier has a page of links:

<a style='text-decoration: underline;' href="http://peltiertech.com/Excel/Pivots/pivotvba.htm" target="_blank">http://peltiertech.com/Excel/Pivots/pivotvba.htm</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Excel 2004 and pivot tables 
Back to top
Login to vote
Chris Waskowich

External


Since: May 19, 2004
Posts: 3



(Msg. 3) Posted: Wed May 19, 2004 6:05 pm
Post subject: Re: Excel 2004 and pivot tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 2004-05-19 13:09:09 -0400, JE McGimpsey <jemcgimpsey DeleteThis @mvps.org> said:

 > I can't reproduce this with any files with PTs. Does it happen with a
 > fresh workbook?

Interesting. No, it does not happen on a 'fresh' workbook. I've tried
'Save as' to a clean workbook and it still bails. I'll just have to
re-create the entire workbook. Uhg. At least it is not as
catastrophic as I had originally thought.


 > If you're just changing the range, you may be interested in using
 > dynamic ranges instead:
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://www.contextures.com/xlPivot01.html</font" target="_blank">http://www.contextures.com/xlPivot01.html</font</a>>

Thanks for the link. It looks like this could help out.


 > As for a macro (which is just a script written in VBA, so I'm not sure
 > what you have against them), start by recording a macro while you
 > generate your PT. For more help, Jon Peltier has a page of links:
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://peltiertech.com/Excel/Pivots/pivotvba.htm</font" target="_blank">http://peltiertech.com/Excel/Pivots/pivotvba.htm</font</a>>

I was referring to the old Excel 4.0 macros. Do people still use
these, or am I the only one ? ;) Thanks for this link too.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Excel 2004 and pivot tables 
Back to top
Login to vote
Chris Waskowich

External


Since: May 19, 2004
Posts: 3



(Msg. 4) Posted: Wed May 19, 2004 8:57 pm
Post subject: Re: Excel 2004 and pivot tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On 2004-05-19 13:09:09 -0400, JE McGimpsey <jemcgimpsey DeleteThis @mvps.org> said:

 > I can't reproduce this with any files with PTs. Does it happen with a
 > fresh workbook?
 >
 > If you're just changing the range, you may be interested in using
 > dynamic ranges instead:
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://www.contextures.com/xlPivot01.html</font" target="_blank">http://www.contextures.com/xlPivot01.html</font</a>>

Well, I created the workbook from scratch and it still bails. I didn't
copy any worksheets over to the new workbook... the only thing I
copied was the data, but I got that from the original source - not the
workbook. So, it must be something about the data that I have that is
causing Excel to get all mad.

I did try out the dynamic data range techique and it worked just fine,
but when I copied the one of the pivot table worksheets to another
worksheet and tried to change the data source, that is when it bailed.

I guess I'm going to have to create each pivot table from scratch...<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Excel 2004 and pivot tables 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 5) Posted: Wed May 19, 2004 8:57 pm
Post subject: Re: Excel 2004 and pivot tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In article <2004051917570584750%cwasko@NOmacSPANcom>,
Chris Waskowich <cwasko.RemoveThis@NO-mac-SPAN.com> wrote:

 > Well, I created the workbook from scratch and it still bails. I didn't
 > copy any worksheets over to the new workbook... the only thing I
 > copied was the data, but I got that from the original source - not the
 > workbook. So, it must be something about the data that I have that is
 > causing Excel to get all mad.
 >
 > I did try out the dynamic data range techique and it worked just fine,
 > but when I copied the one of the pivot table worksheets to another
 > worksheet and tried to change the data source, that is when it bailed.
 >
 > I guess I'm going to have to create each pivot table from scratch...

If it's not proprietary, I'd be willing to take a look at your workbook.
Since I can't reproduce it, it's hard for me to suggest something...<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Excel 2004 and pivot tables 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 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



[ Contact us | Terms of Service/Privacy Policy ]