Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Hardware > Notebooks > MacBook Air

Reply
 
Thread Tools Search this Thread Display Modes
Old Dec 1, 2010, 07:27 PM   #1
markr346
macrumors newbie
 
Join Date: Nov 2010
MBA 13 problems with Excel Office 2011

Two strange issues that I can't fix on my new MB Air 13 with MS Office for MAC 2011 and Excel.

1) I can't get the Standard Toolbar to show up when I open a new worksheet. I go to view, toolbars and then see that the Standard Toolbar is checked, but it doesn't show up. The only way to get it to show up is to do a series of steps:
- uncheck Standard Toolbar menu and go back out;
- go back in and check the Standard Toolbar and back to the spreadsheet - the Standard Toolbar still doesn't show up;
- so then I click on the Layout tab on the ribbon ... and then it shows up!

2) I can't see the bottom of the window/spreadsheet -- which means I can't resize the window. To resolve this, I have to do these steps:
- open system preferences, and change my MB Air screen resolution from 1440 x 900 down to 1280 x 800 ...
- then go back to the spreadsheet, and resize the window (make it smaller on the screen)
- go back and resize the window back to 1440 x 900
- and then close the system preferences ... at this point, the Excel spreadsheet window is smaller and I can see/use the bottom of the screen to resize, etc. etc. etc.

Strange ... can't figure out what setting I have wrong or why I can't get Excel for Mac 2011 to work correctly on the MB Air screen ...

Any ideas or solutions is appreciated.
markr346 is offline   0 Reply With Quote
Old Dec 2, 2010, 12:56 AM   #2
robby818
macrumors 6502a
 
Join Date: May 2007
For #2 if you hit the green button (top left corner of the window) the window goes to max. then resize by grabbing the lower right corner to make it smaller. Now toggle the green button and it should behave correctly. I think the setting should stick if you quit excel and restart but I did not test it. I noticed this issue too on my MBA 11"

Last edited by robby818; Dec 2, 2010 at 01:46 AM.
robby818 is offline   0 Reply With Quote
Old Dec 2, 2010, 01:20 AM   #3
teski
macrumors regular
 
Join Date: Oct 2010
I'm not seeing either of those. When Excel 2011 opens, I can see the full worksheet. If I click the green +, it just extends the right side to fill the screen, but never does the bottom disappear.

As for the toolbar, the standard shows up at launch and I can't repro what you're seeing.

Has it been this way since you first installed?
teski is offline   0 Reply With Quote
Old Dec 2, 2010, 09:01 AM   #4
markr346
Thread Starter
macrumors newbie
 
Join Date: Nov 2010
Yes, it's been that way from the start.

Got a fix directly from Microsoft. Here's what must have happened.

I had a MBPro 15" with Office 2008 and I did a Time Machine transfer from the MBP 15" to the MBA 13". On the MBA 13" I upgraded to MS Office 2011 for the MAC ... but I must have kept some of the 2008 preferences after doing an uninstall of 2008.

Microsoft told me I needed to delete these two items in my preferences file (they commented I might have some "corruption in my Excel preferences"):
- com.Microsoft.Excel.plist (drag to trash and delete)
- the Microsoft Folder (drag to trash and delete)

After doing that, the Standard Toolbar was fixed and now shows up.

And the bottom of the spreadsheet, and the screen sizing corner tool, now show up so I can resize Excel screens, etc. Both problems fixed. Must have been corrupt preferences.

BTW - love the MBA 13" ... no degradation in performance over my late 2007 MBPro 15" ... and love the size/weight and speed at start-up and shut-down.

Thanks for the comments.
markr346 is offline   0 Reply With Quote
Old Dec 2, 2010, 09:34 AM   #5
teski
macrumors regular
 
Join Date: Oct 2010
Quote:
Originally Posted by markr346 View Post
Yes, it's been that way from the start.

Got a fix directly from Microsoft. Here's what must have happened.

I had a MBPro 15" with Office 2008 and I did a Time Machine transfer from the MBP 15" to the MBA 13". On the MBA 13" I upgraded to MS Office 2011 for the MAC ... but I must have kept some of the 2008 preferences after doing an uninstall of 2008.

Microsoft told me I needed to delete these two items in my preferences file (they commented I might have some "corruption in my Excel preferences"):
- com.Microsoft.Excel.plist (drag to trash and delete)
- the Microsoft Folder (drag to trash and delete)

After doing that, the Standard Toolbar was fixed and now shows up.

And the bottom of the spreadsheet, and the screen sizing corner tool, now show up so I can resize Excel screens, etc. Both problems fixed. Must have been corrupt preferences.

BTW - love the MBA 13" ... no degradation in performance over my late 2007 MBPro 15" ... and love the size/weight and speed at start-up and shut-down.

Thanks for the comments.
Excellent! Glad it was fixed!
teski is offline   0 Reply With Quote
Old Jan 9, 2011, 03:42 PM   #6
LGF
macrumors newbie
 
Join Date: Jan 2011
Location: Norway
Quote:
Originally Posted by markr346 View Post
Yes, it's been that way from the start.

Got a fix directly from Microsoft. Here's what must have happened.

I had a MBPro 15" with Office 2008 and I did a Time Machine transfer from the MBP 15" to the MBA 13". On the MBA 13" I upgraded to MS Office 2011 for the MAC ... but I must have kept some of the 2008 preferences after doing an uninstall of 2008.

Microsoft told me I needed to delete these two items in my preferences file (they commented I might have some "corruption in my Excel preferences"):
- com.Microsoft.Excel.plist (drag to trash and delete)
- the Microsoft Folder (drag to trash and delete)

After doing that, the Standard Toolbar was fixed and now shows up.

And the bottom of the spreadsheet, and the screen sizing corner tool, now show up so I can resize Excel screens, etc. Both problems fixed. Must have been corrupt preferences.

BTW - love the MBA 13" ... no degradation in performance over my late 2007 MBPro 15" ... and love the size/weight and speed at start-up and shut-down.

Thanks for the comments.
Eh... For a guy who's not that familiar to location of files... Could you please tell us were those two items are located? I do have the same problem, but I couldn't find the .plist file or the folder...

Thanx...
LGF is offline   0 Reply With Quote
Old Sep 19, 2012, 12:09 PM   #7
themunn
macrumors newbie
 
Join Date: Sep 2012
File Location

I had the same problem. An easy fix by deleting the preference files.

The files are located in user > preferences.

Cheers
themunn is offline   1 Reply With Quote
Old Nov 13, 2012, 08:45 AM   #8
redkiteflyer
macrumors newbie
 
Join Date: Nov 2012
No Toolbar in Excel

I have the same issue, and also can't find the preference files
I don't have a folder called 'User' anywhere.. I looked under the folder of my name but there isn't one under that called 'Preferences'

Know I'm being really blonde, but if you can help I'd really appreciate it. I have to do the same workaround as 'markr346', i.e. uncheck the already 'checked' tool bar options under View, and then check them again. Very frustrating.

I'm still on Excel for Mac 2008 and using a 13" MacBookPro and it has always been this way... Until now I didn't use Excel that much on this machine, but I am about to do some work for a client and have to use my own machine!

Thanks in advance
redkiteflyer is offline   0 Reply With Quote
Old Feb 12, 2013, 08:13 AM   #9
keltoid
macrumors newbie
 
Join Date: Jul 2008
The files are located in user > preferences.



^^^ Some others asked, but no response was given - don't know where to find this. I was hoping to find out how I can get Excel files (from others) to open so that I can see the bottom (Status bar) -- so I can see if there are tabs with additional information I need, without having to go to View Full Screen all the time. Just want it to open and not show me all the extraneous rows that have nothing in them- is this possible? Working on an Imac with OSX. Any help you can give is appreciated.

Could not find a "user/preferences" location with Microsoft plist files to delete.
keltoid is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Hardware > Notebooks > MacBook Air

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Visual Basic Module/Macro works in Windows Excel but not Mac Excel 2011 chrispy1042 Mac Applications and Mac App Store 2 May 4, 2014 07:41 AM
2011 Excel for Mac on MBA in Maverick bgent OS X Mavericks (10.9) 3 Mar 7, 2014 01:40 AM
Excel problem (mac office 2011) guvendereli Mac Applications and Mac App Store 2 Aug 16, 2012 11:35 AM
2011 MBA Problems vtyler98 MacBook Air 0 Jul 28, 2012 01:57 PM
Creating Pivots in Excel 2011 that can be used in Excel 2003 (Windows) Extreme Red Mac Applications and Mac App Store 2 Jun 5, 2012 09:51 AM

Forum Jump

All times are GMT -5. The time now is 08:27 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC