Microsoft Office for Mac 2011 tutorial: Excel basics 1 Excel&basics! Excel is a powerful spreadsheet and data analysis application, but to use it most effectively, you first have to understand the basics. This tutorial introduces some of the tasks and features that you can use in all workbooks.
Hi, I have an excel file which was created under Windows. If I open it on Mac, Excel crashes. I have tested using another Mac and the same issue occured ( Mac version: Yosemite. Office version: 2016) Any advice and help would be greatly appreciated. Hi, I noticed that the issue only occurred when you open a specific Excel file. Please confirm if there is any issue when you open a new workbook in Excel application. If you can open a new workbook in Excel, then click File Open to open this file to have a try.
- Mar 19, 2017 - Hi, I will buy a laptop for work and chill at home. I mainly work with heavy excels and i was wondering if excel is OK on mac?
- Finally, some Excel shortcuts are just plain different on a Mac. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T.
Additionally, please save as this specific Excel file to another file format (.xls) on Windows. Then open it on Mac and confirm if the issue persists. Regards, Winnie Liang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Hi, Is the problematic Office 2016 application upgraded from Office 2011 instead of a fresh Office 2016 installation on Mac? Please refer to the following article to completely remove any remained Office 2011 application files on Mac: Additionally, please completely uninstall Office 2016 from Mac then reinstall a fresh Office 2016 app on Mac: Regards, Winnie Liang TechNet Community Support Please mark the reply as an answer if you find it is helpful.
If you have feedback for TechNet Support, contact. Hi, Sorry for my delay.
In Excel for Mac 2016, I can open an Excel file created on Excel 2013 for Windows. If your issue is related to a specific file, please save it to a new workbook as.xls to have a try. If the issue persists, please share the Excel files to us via GBSD TN Office Information Collection.
We would open your problematic file in our test environment. Please involve the thread URL in the email message for easy follow-up:) Regards, Winnie Liang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Hi, We have received your Excel file. I was also unable to open your Excel file on my Excel for Mac application. But other Excel files created on Excel for Windows can be opened fine on Mac. So strange that the issue only occurred on your Excel file. It is difficult to determine which feature caused the file opening issue on Mac. We would do further analysis on your Excel file. If there is any updates, I would follow up here:) Regards, Winnie Liang TechNet Community Support Please mark the reply as an answer if you find it is helpful.
If you have feedback for TechNet Support, contact. Hi Winnie I am having the same identical problem with a handful of my excel files. Some open fine, some crash. All worked fine on this computer before, then one day they crashed when I opened them. I have tried all of the work arounds listed in this thread (I can open the files on a PC without a problem) and have had the same results as @porskipors. I am running OS X El Capitan 10.11.5 and Excel for Mac version 15.23.2. This was a clean instal of Office on a new computer, and has worked fine (including these files) for about 6 months before this problem occurred last week.
Why Is Excel For Mac Free
Just wanted to let you know that this problem was not unique to the file you received from @porskipors. I will follow this thread for any updates. Hi, Sorry for my delay. I was busy on working on other threads and missed this one. Apologize for my mistake. I did many many test for your problematic Excel file between Windows and Mac.
Copy sheets to new workbooks respectively. Check the sheets one by one. Change the saved file format etc. Finally, I found a workaround and was able to open this file on Mac now. I changed your Amount column formats to Currency. And it worked!!!
I noticed that there are many different format set for your number cell. In your scenario, Accounting and Custom format are used. For example: Now, I changed it all to Currency format.
Why Is Excel For Mac Download
I have uploaded the final worked Excel file to my OneDrive, please download it and open it on Mac to have a try: Personal opinion, I think the reason why your Excel file failed to open on Mac is the number format for Excel on Windows and Mac may be different. For example, the Accounting Symbol for Thailand are different. For Windows: For Mac: Hope the problematic Excel file can work fine on your Mac now:) Regards, Winnie Liang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact.