I have Excel for Mac 2016 (version 16.9-180116) installed on a MacBook Pro with 8GB of Ram. Since the latest update to Excel, it keeps crashing when I try to copy data from a csv file to another workbook. There is a lot of data (27,500 rows) so after it crashed the first time, I set calculation to manual and copied over 10,000 rows at a time.
Although it’s true that you can gain a better knowledge of any application if you visit its preferences and try to figure them out, it’s almost essential for Excel for Mac 2011. Choose Excel→Preferences from the menu bar to display the Preferences dialog. When you have an inkling or thought about a setting you want to change, just type into the Search field.
Here are some selected settings:
- General:
- Sheets in New Workbook: The spinner sets the number of blank worksheets a new workbook will have by default.
- Standard Font: Choose a default font. Unless you have a compelling reason to change this, leave this as “body font,” which is roughly the same as the default font.
- Preferred File Location: Set the default location for Excel files.
- Show This Number of Recent Documents: Set the number of recently used workbooks shown in Excel’s File menu by typing in a figure here. Recently used items in the File menu don’t disappear after a month. This list is based on the quantity you set.
- View:
- Comments: Adjust how comments are displayed.
- Show Formulas: Display formulas instead of calculation values.
- Show Zero Values: Displays a 0 instead of an empty cell when selected.
- Show Sheet Tabs: Deselect to hide all the sheet tabs with the horizontal scroll bar. Selecting redisplays the scroll bar.
- Edit:
- Automatically convert date systems: When selected, Excel automatically corrects for differences between the 1900 (Windows) and 1904 date systems (Mac) during copy and paste. The destination workbook’s format is adopted.
- AutoCorrect: You can have Excel fix your common typing blunders automatically.
- Calculation: When not set to Automatically, working with large spreadsheets with lots of complicated formulas can be faster and easier.
If you turn off Excel’s automatic calculation capability, you need to turn it back on again, or Excel’s formulas won’t calculate. This is especially important if you turn off automatic calculation using a macro. Be certain your code turns the Automatically option back on under all circumstances.
Hi Ftb2000,
From your description, the issue may be related to the csv file which contains a lot of data. Meanwhile, I suggest you try the following steps to check the outcome:
Note: Please back up the cxv file to protect your important file.
1)Quit all active desktop applications.
2)Start Excel with Mac safe mode.
3)Try importing data from CSV file to another workbook.
Meanwhile, I’d like to confirm the information below to troubleshooting:
1)Does the issue occur if you copy data from a csv file with not much data?
2)Please check if the issue occurs when you copy data from other file formats.
Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.
Regards,
Virgil
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
Virgil,I tried the steps you outlined in your message. In safe mode, Excel performs very strangely. The source file opens with an all white screen, but I can tell there is data there by clicking on the screen and seeing the value in the formula bar. The target workbook shows up with an all black screen, but again I can tell there is data under there by looking at the formula bar.
When I select all on the csv file and copy/past to the target workbook, Excel goes into endless spinning and I have to “force quit” the program. The Activity monitor shows Excel using 100.4% of cpu capacity.
I also copied and pasted the data into a blank workbook and that works OK with the full 28,000 rows. I also tried copy/paste in sections of different sizes into the target workbook (10k rows, 10k rows, 5k rows, 2k rows, 500 rows). The first 27,000 rows came in OK, but the system hung up on the final 500 row paste (by the way, I’m pasting the data into an Excel Table on the target workbook with calculation turned to manual). Also, the source file is a delimited text file exported from another application which I bring into Excel and then copy/paste the rows into my target workbook.
As I mentioned in the original post, I’ve been doing this process every month for years with no problem. It’s just since I upgraded to the most recent version of Excel 2016 and Mac OS 10.13 that this problem has occurred. I’m running a MacBook Pro with OS 10.13 and 8 Gig of Ram.
Hope you can find some way to fix this.
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
Hi Ftb2000,
Thanks for your so detail clarify. As you mentioned that when you copy the CSV file data into blank workbook, Excel won’t crash with full 28000rows. And if you copy the CSV file data into the target workbook with formula, the first 27,000 rows came in OK, but the system hung up on the final 500 row paste. Given this situation, the reason may be when you copy the CSV file to the target file and the formula may be also affected although you turn calculation to manual which cause the high CPU usage.
Meanwhile, We suggest providing feedback to our Office 365 Excel UserVoice. This is the best way to make our products and services better for you and others. We appreciate your understanding.
Best Regards,
Virgil
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
Mac Excel Manual Calculation Download
Virgil,
the problem appears to be with the excel tables. When i convert the table to a range, i can copy/paste the entire 27,500 rows to the target workbook. I then have to re-create the excel table with the data. I’ve tried this twice with two different source files and two target worksheets. Both hang up when i try to paste into an existing excel table, but work OK if i first convert the table back into a range.
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
There is an update available. Please install it and reply as to whether or not the update fixes this problem. Thanks.
Make sure your Mac has a working internet connection before checking for updates. Install Mac OS X updates followed by Office updates.
Install Mac OS X updates first:
To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates.
Then Install Office Updates
Excel Manual Calculation Shortcut
To get the update:
- Open any Office application
- Go to the Help menu and choose Check for Updates
- Let AutoUpdate check for and install updates
- Restart your Mac
If you have any add-ins such as WebEx, Mendelay, EndNote, Zotero, TypeIt4me, etc it is essential that you install the latest updates for your add-ins.
I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support. 2 people were helped by this reply
·Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.