Nov 09 2017 12:17 AM
HI, i'm using office365 for business at 64bit on a 64bit OS - Updated at the last security fix.
I have a workbook with 10 sheets, one of them have 50.000 rows and 115 column.
The relative SHEET1.BIN has a weight of 250mega.
The workbook is about 50-60mega.
The sheet1 doesn't reaches at the excel xlsx limit (above 1.000.000 rows and 255 column) with the scroll bar.
The workbook use formulas that refer to the other sheets of the same workbook. It doesn't have any type of external relation.
In the sheet1 we can find formulas like VLOOKUP, SUMIF, and SUMIFS nothing really complex, complicated.
There are no circular references.
AS I said the sheet1 is very slow it takes 1 minute or more to set any filter. It's slow with calculation too.
The opening of the filter menù is immediate, but when i select one element or more in any filter it takes too much time.
I tried in every possible way, by deactivating auto calculation without getting any results.
I'm using xlsb format but nothing change if i use other format (xlsb,xlsm etc)
I think that the problem is in the SHEET1.bin that is very huge (250mega)
What solutions i can apply to make it more useable?
I can't split it and it doesn't have any type of conditional formatting and no multimedia contenents
if i scroll with the mouse o keyboard pag.up/pag.down is fast as normal.
I tried to use OFFICE 2013 pro not 365 but nothing has changed.
I tried to use different version of windows 10 instead of 8.1 but nothing has changed.
By editing the sheet1.bin with an hex editor what i can get?
I don't understand the code that the hex editor display...
I tried using excel in safe mode but nothing has changed.
Thank you
Nov 09 2017 12:32 AM