excel >> Pivot Table weaknesses

by ken_merson » Thu, 04 Dec 2003 07:23:48 GMT

Have only just come back to Mac as a business tool and today I found a
major weakness in MS Excel X compared with the equivalent in PC.

I am beginning to believe my colleagues when they tell me that Macs &
PC's are just not compatible, skills on one system are not
transferable.

For example; Have run Pivot Tables on PCs with out any issue,
analysing lines and lines of data. Decided to try and do the same work
now using the Mac and Office X Excel.

It is a classic Excel spreadsheet of companies, areas, sales etc. But
creating a Pivot Table in Excel X is just not the same and in fact
when you have created the supposed table, you can't even sort the data
as you can in PC.

Even in Mactopia webpage example, the same result is seen, which I
suppose is fine if you are limited to two locations of information to
process.

Why can't it be the same as PC and if I'm using this system correctly,
then the advertising needs to change, because it is false.

Look forward to hearing from someone.

excel >> Pivot Table weaknesses

by Jim Gordon MVP » Wed, 10 Dec 2003 10:17:47 GMT


Hi

AFAIK pivot tables work the same in Excel X and Excel for Windows except
that Excel for Mac does not support OLAP cubes.

I tried to find a "how to" article on MacTopia that involves pivot tables
but could not. I checked here:
http://www.microsoft.com/mac/products/excelx/using.aspx?pid=usingexcelx

Which article are you referring to?

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
< http://www.rondebruin.nl/Google.htm> ;

----------
In article < XXXX@XXXXX.COM >,

excel >> Pivot Table weaknesses

by Eric Swanson » Wed, 17 Dec 2003 09:44:37 GMT

I have had similar problems with Pivot Tables.

I have written down a procedure (directions) to make a Pivot Table. When I
follow my directions on the PC version of Excel it works, but when I do the
exact same thing on the Mac version of Excel (SP 1), I get some error like
'too many items in table' or something on the Mac. Quite annoying, forces
me to use a PC for this task.

Eric S


On 12/3/03 5:23 PM, in article
XXXX@XXXXX.COM , "Ken Merson"

excel >> Pivot Table weaknesses

by Jim Gordon MVP » Wed, 17 Dec 2003 13:08:47 GMT

Hi Eric,

Such a tease! It sure is hard to see what you have written from here. Care
to share what steps you took with the world?

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
< http://www.rondebruin.nl/Google.htm> ;

----------
In article <BC051125.143B% XXXX@XXXXX.COM >, Eric Swanson

Similar Threads

1. XP: Cool feature with a weakness (CSMA_Moderator weakness)

2. Pivot Table and Pivot Table dates are not in correct order

I have a pivot table that has a date field that is coming up out of order. 
The column is labeled week ending data and the week of 7/10/09 is coming up 
before 7/3/09. I need to get this back in line because it is throwing my 
charts off. Can you tell me what to do to correct it.  

3. Filter lines with Pivot table and non pivot table columns - MS Excel Charts

4. Copying values from pivot table to cells outside pivot table

I have what is probably a unique question, and kind of hard to explain, so I 
have included a sample of how it should look.  I have data in a pivot table 
on Excel.  It consists of employee 3, a pay code, and hours belonging to that 
pay code.  Each employee could have 1, 2, 3 (or more) rows of data.  I want 
the copy the employee's hours within the pivot table to columns that are not 
within the pivot table.  All of the hours have to show up on the top row for 
that employee, and under a column specific to that pay code.

Below, I have a sample of how I want this to look:

(columns A, B, and C contain the pivot table; columns D and on are where I 
want to copy the hours from column C.  The hours should be copied to the top 
row for that employee; and to the column that corresponds to the code 
indicated in column B

      A          B          C            D             E           F         
  G
1                                         REG        HCC        ITC          
SCC
2
3   ID        Code     Hours
4   123	REG       57.10     57.10        5.82       22.43   
5	ITC        22.43
6	HCC       5.82
7
8   456	REG       62.25      62.25                    27.15          3.5
9	ITC        27.15
10	SCC       3.50
11  
12  789     REG        61.50      61.50                   25.6
13            ITC        25.6


5. Distributing Pivot Tables where pivot table data can't be accessed - Excel

6. Filter lines with Pivot table and non Pivot table columns

I have created a pivot table. Next to the pivot table are columns to enter 
data and then additional clolumns to add the pivot table and not pivot table 
data. I am running a filter on a column in the pivot table, and the non 
pivot table data entered does not hold with the pivot table line. (For 
example, I have an line in the pivot table (say line 20) call "item 1". I 
enter a value in a Column outside the pivot table to correspond to item 1 on 
line 20. When I filter on "item 1" - it now moves to line 5; however, the 
amount I manually added to line 20 outside the pivot table stays on line 20, 
but I want it to move to line 5 with the pivot table data

7. Pivot Table - Use Other Pivot Table as Data Source - Excel

8. Pivot table "save data in pivot table" option

I have been able to reduce the file size by unclicking 
the option "save data in pivot table".  I can't seem to 
find an article on the web that will explain to me if I 
will lose functionality of the pivot table if I turn this 
option off.

Can you help?