problem in excel-PLEASE it very important

[zoharb]

Respected,
I have a big file of 400MB+ which has lot of functions.
Just 15 days ago I was able to copy a line of 50+functions to another place in just 2-3 seconds
but now it takes 2-3 minutes.
I have tried every thing like
(1)completely writing new formulas so that there might be some routine that was delaying but it is not working
(2)completely making new workbook from scratch.
(3)Has removed all conditional formating, unicode characters , iterations
But nothing is solving my problem
Can anyone please guide me
OR
someone please show some utility/application which points out particular formula which causes that lag
PLEASE it very important

 

[zoharb]

only values version is just of 78000KB

 

[zoharb]

Respected,
Has tried pasting formulas with Values(not functions-formattings in there) version.And its working correct;y and also is consuming CPU as was done before.Now the thing to see that will it behave the same after gaining size(because at low size wven this version was working normally but started to show lag when size increased) .Please give your suggestions.
Zohar Batterywala

 

[zoharb]

You're welcome to post a copy of your workbook to a file sharing site, then post the link here. Just make sure to remove any sensitive personal information.

Regarding a 400+ Mb workbook, even if you've made a lot of accommodations to make Excel work well, I'd still be looking at what you're trying to do before wondering why Excel won't support it. I don't know your data situation, but have you looked at big data modeling options, like Power Pivot?

Respected,
Has uploaded both file-with function and only values in dropbox.
https://www.dropbox.com/sh/sijvsxcxaeeh4tj/AAAHOMJg4vJ0aTYfTf2ZvEGCa?dl=0

The with functions file is heavy so takes a minute or so to open but you can see CPU working in that time(though excel at that time remains blank-other apps will work as usual) shows 40%+ load on my i3-6100 CPU with 8 GB DDR$ RAM)

Please give suggestion

Zohar Batterywala

 

[Yongle]

See my first reply in post#2

you probably have some formatting or conditional formatting rules that need to be amended (are you using comlete columns when you could specify a much smaller range etc)

Try removing all the unnecessary formatting from your worksheet - You have formatted many complete rows and many complete columns
Remove all formatting from outside the data range

Excel is allocating every row and every column into memory = 17 BILLION cells
That is what is killing your PC



[TABLE="width: 84"]
<tbody>[TR]
[TD="width: 84, align: right"][/TD]
[/TR]
</tbody>[/TABLE]