Excel is Growing!

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
That's awesome!!!

And long overdue!
 
Upvote 0
I agree. :)

I just hope the Calc. Engine grows respectively, I'm having visions of Spreadsheets crashing around the World! :o
 
Upvote 0
About time too!

I wonder if there will be noticeable improvement in the calculation engine on older computers or whether they are presuming faster processor speeds to sort out the calculation nightmare of 1million rows of Vlookups!

Richard
 
Upvote 0
Yeah, hope they do something about the speed, especially with array formulas.

Got a 40mb project management spreadsheet hooked up to financial statements to do forecasting and scenario analysis.

Takes almost a minute to calculate and upwards of a half an hour to run a full scenario!!!
 
Upvote 0
Whilst an increase in the number of rows and columns will be universally welcomed, I wonder if users will default to Excel where previously they were forced into Access or other creative solutions given the row limit constraint will effectively disappear (for the average user anyway). We might see Excel used more frequently like a database, resulting in hardware upgrades to accommodate inefficiently designed spreadsheets. Over time we might see a lot more questions on the Excel board of the speed / size variety. We shall wait and see!

Andrew :)
 
Upvote 0

Forum statistics

Threads
1,224,830
Messages
6,181,229
Members
453,026
Latest member
cknader

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top