Is this excel file particularly large: performance problems on Excel (Mac)

[hkokko]

First a generic question:

Is 8000 rows with very simple calculations in half of the columns extending to column "BK" or so a large excel file? What are the largest excel files that you have used/seen...

[FONT=Arial, Helvetica, sans-serif]Why I ask: I have ran into performance problems on an excel file that has the above characteristics. What could I do to make it faster. The number of rows is likely to grow year by year... [/FONT]

[FONT=Arial, Helvetica, sans-serif]Background:[/FONT]

[FONT=Arial, Helvetica, sans-serif]Running the latest official versions of Office 2016 on Mac and El Capitan (10.10.1)[/FONT]

In one of my spreadsheets (the biggest one) the below are more evident than in the others. The others are smaller and do not have so many calculations

The biggest one is containing about 8000 rows with calculations in half of the columns extending to column "BK" or so.

I have five issues

- 1) Excel is crashing all the time - if I have tables on it crashes almost after every operation. This with any of the spreadsheets I have.

- 2) Excel is especially slow if using sheets as tables (not as ranges). Every operation in user interface has lots of lag. As soon as I convert back to range with table tools performance is back to "normal".

- 3) Excel is relatively consistently - perhaps not "always" but almost always failing to copy the formulas to part of the columns when I copy a row. It changes all the formulas to values at least from columns AF onward). This has been true already with Excel 2011 but continues with this 2016 version.

- 4) The normal is : Excel is very slow especially in filtering, copying rows...

- 5) After going above maybe 5000 rows of data recently the UI started to lag a lot (partial refreshing, takes a long time (several seconds to update part of the screen)...

This happens with three year old MacBook Pro 15" Retina with 16gb and the mid size CPU of that time (2.5 or 2.7Ghz).

 

[Jim Gordon]

Microsoft hasn't optimized Excel 2016 for speed yet. Use 2011 if speed is important. Otherwise, just keep installing updates to 2016 and Mac OS X so that when speed optimization is implemented you get the benefits right away. You're behind in your updates even now. Make sure your Mac has a working internet connection before checking for updates.

Mac OS X updates:
To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates.

Office Updates
To get the update:
1. Open any Office application:
3. Make sure your Mac has a working internet connection
4. Go to the Help menu and choose Check for Updates
5. Let AutoUpdate check for and install updates