Software :: Office Mac 2011 / Excel Macros Restored?
Oct 27, 2010
I've seen conflicting information about the new Office Mac release. Have Macros been restored to Excel? And if so, what language are they using? Has anyone tried them or tried to import Macros from Excel 4 or Excel 5 macro languages?
I had to restore my MacBook Pro the other day. Microsoft Office 2011 was installed at the Apple Store and now I can't find the registration code. Where is it?
has anyone had an issue with office mac 2011 excel and osx lion? i make excel spreadsheets with pdf storyboards on them, and too often the excel file will not reopen. instead i get a corrupt file notice. i choose fix file and the file opens without the pdf files. sounds like a pdf/excel issue to me. it is maddening.
I looked and I didn't find any info so I just wanted to tell you that Solver for Excel Mac 2011 is now available as a free download here: http://www.solver.com/ This guys also have some other really cool tools if you want to check them out.
Does anybody know where the controls / forms toolboxes are. Just got to the end of building a spreadsheet, and cannot find the control toolbox anywhere for adding spinners, check boxes etc. Is it even included anymore, as web searches draw a total blank for me.
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 MBA 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.
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.
I know Excel 2008 does not support VB macros, but did anyone notice that "Macros..." is still available under the Tools menu? I wonder why it's there? BTW, I saved an old file in Excel 2008 that had macros and then opened it in Excel 2004 to see if the macros are still there. They are. That's a big relief, because I know I can at least work on files that have VB code in them without worrying that if I save the file in Excel 2008 format the macros will go poof. Ooof
I updated to Lion on my desktop a few months ago and I swear now I can't read older Microsoft word and Excel documents correctly on this computer using Office 2011. The document opens and you can see all of the data in a preview window (from finder) but once it opens fully the data/words are not there. I have Lion on a brand new Macbook Pro I just purchased and installed the Microsoft Office 2011 and it opened the excel document I was having trouble with fine.I can't find many links for Office for Mac issues.
I forgot my administrator's password for my home computer. I purchased office 2008 for mac with a free upgrade to office 2011. I upgraded it to 2011 when it came out (late 2010/early 2011). I have since made a new password and forgotten what it is. The mac tells me to reinstall my microsoft office but when I do, with the office 2008 disc, it tells me I have MORE RECENT SOFTWARE and to use that. I did it on line and cannot find it again.
So I got Office 2011; it's pretty good stuff. Unlike Windows based systems, it did not remove Office 2008 which is different. I am wondering if there is any reason that I should or should not remove 2008 since I have 2011 (exact same programs).
I've had great success with Excel 2011 on OS 10.6.8. Up until today. Now, Excel crashes on launch, tries to recover, and crashes again. I read the previous comments about a) hold down shift key and launch and b) delete the /plist file. Tried both, no success. I can still launch Excel 2008, fyi. And Word, etc, all other MS office products...
Info: MacBook (13-inch Aluminum Late 2008), Mac OS X (10.6.8)
MS has added many styles to default worksheet in 2011. Previous versions I could create my own default workbook and put it in the Startup folder for Excel. That does not work in 2011. Anyone able to tell me how to use my former default sheet in 2011 (don't want to Template feature)? I am talking about the sheet created when you start Excel.
It's supposedly the shortcut to Paste Special in Excel 2011. It's not working for me. Maybe I'm hitting the keys wrong? You can see it if you go to the Edit menu. thank you.
I am upgrading to Lion and Microsoft Excel and Office will not run under Lion.I am upgrading to office 2011.Do I need to uninstall office 2004 prior to installing 2011.If so how do I uninstall 2044.
I am experienced in Excel VBA on the PC but not on the Mac. I am building an application on my PC that will run on my sister's Mac (latest OS, Excel V14.0.2). The problem involves the use of FormulaARRAY in my code. I have extracted the problem statement into a small example routine shown below: Public Sub example() Dim lastcol As Long With ActiveSheet lastcol = 12 .Cells(4, 6).FormulaArray = "=SUM((MOD(COLUMN(RC9:RC" & lastcol & ") -COLUMN(RC9),3)=0)*(RC9:RC" & lastcol & "))" End With End Sub
Here is one of the correct and working formulas that resulted on the PC (note the brackets for the array formulas are missing but they are there. I got what I am showing by using the 'display formulas' option which apparently does not show the brackets): =SUM((MOD(COLUMN(RC9:RC12)-COLUMN(RC9),3)=0)*(RC9:RC12))
Here is the incorrect and non working formula that resulted on my sister's Mac: (again the brackets are there) =SUM((MOD(COLUMN(R[5]C[465]:R[8]C[465])-COLUMN(R[5]C[465]),3)=0)*(R[5]C[465]:R[8]C[465]))
Both systems were set to display R1C1 Reference Style. This is irrelevant on the PC and I would assume the same for the Mac. I bought an old G4 for $60 to use to debug my PC code in the Mac environment. Curiously the code runs fine on it under Excel 2004.
Excel on my mac is so confusing and i have never used it before. It prints out everything but the grid lines for the graph..without the gridlines, the graph looks weird and not easy to read..The print preview shows the grid lines on the mac but when it prints out, i get a weird graph..
How do I do it? I want the document to require a password to open. I did the tools-->protection--protect workbook/sheet thing but that didn't do it, the document could still be opened, just not edited. I have a budget sheet with all of my online account passwords I don't want accessible if the computer gets stolen.
The printing area is smaller than the page I want to print, 3 or 4 columns are on an other page to the right of the print area that I can print, I am not great on excel but would like to move the printing area so it can take all of it.
I'm trying to turn on the excel functionality where I can see shortcuts when I hover over a button e.g. the bold button i would expect to see something like this "bold cmd+B". I have tried searching communities but I could find the answer. I found the answer for windows but not for mac. Below you can see a screen print to illustrate the issue. Excel only shows "bold" when I hover over the bold button and not "bold cmd+b". Im using excel 2011.
The planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.
The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.
Does anyone know how to set the Excel (2008 version) toolbars at top of app to remain as a saved preference? I've tried everything and when I quit Excel and re-open, everything I've changed about the toolbar view is gone and I'm left with nothing. It wasn't like this all along, and somehow I ended up this way.