Excel 2007 not working on MAc OS

**sonal.ag01** · 07-04-2011, 06:27 AM

Hi All,

I have a requirement where I have many excel pivot table reports craeted in MS office 2007. Now, I want to use those reports on a MAC machine but I am unable to use them. I have MAC 10.6.X version and Office 2011 on my MAC machine.

Can anybody help me on how can I use pivot tabke excel report on MAC?

Thanks in advance !!

**romperstomper** · 07-04-2011, 09:02 AM

Pivot tables work in Excel 2011. What specifically is the problem?

**sonal.ag01** · 07-04-2011, 10:27 AM

In my file, I am unable to click on the dropdown signs which coms in the filter section of the pivot tables. On clicking there is an error saying: "This file can't be updated in this version".

**romperstomper** · 07-04-2011, 11:41 AM

Is your copy of Office 2011 fully up to date? There shouldn't be a problem using 2007 or 2010 format files in 2011.

**sonal.ag01** · 07-05-2011, 12:06 AM

Yes it is fully updated. Do we need to instal some add in on MAC as my pivot tables are not getting recognised as pivot tables. If I open my file on MAC and right click then "pivot table options" is also disabled.

Any idea with regard to this ??

**romperstomper** · 07-05-2011, 01:28 AM

No, no addins are required. Can you post a sample workbook that doesn't work in 2011?

**sonal.ag01** · 07-06-2011, 02:43 AM

My pivot table is built on top of SSAS cube. Can that be a problem ?

**romperstomper** · 07-06-2011, 02:49 AM

Yes that is a problem - Excel 2011 does not support OLAP pivot tables.

**sonal.ag01** · 07-06-2011, 03:23 AM

Do any add-in or plug in exist for running these pivit tables on MAC ?

**romperstomper** · 07-06-2011, 03:49 AM

Not that I have heard of.
Note: I may have misspoken earlier (based my answer on an Mac Excel Engineer's post) as it appears 2011 may work with some OLAP cubes, just not MS ones.

Also, if you are going to cross-post, please follow the forum rules and post links here to your cross posts in other forums.