Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#371022 - 15/06/2018 16:46 Excel question
BartDG
carpal tunnel

Registered: 20/05/2001
Posts: 2616
Loc: Bruges, Belgium
I know there are some Excel wizards here on the board, so maybe they know an answer to this question.

I have to work with a pretty big Excel sheet on my laptop. This laptop is a HP Spectre X360 laptop, 2018 model with i7 CPU, 16 GB RAM and a 512GB SSD. Pretty good specs I would think.

Now, when I change the value of a cell in this particular Excel sheet, this doesn't always happen instantly. Sometimes it takes a few seconds for it to change. Same with changing the color of the cell. This is annoying.

What could be causing this? I already changed the energy settings to maximum speed when running on cable, so I don't think that is the problem. I also get the impression it worsens when I've been working for a while, and is better when I reboot the PC, making me think it's some kind of buffer that is getting filled up.

I'm stumped. Any ideas would be appreciated.

Thanks!
_________________________
Riocar 80gig S/N : 010101580 red
Riocar 80gig (010102106) - backup

Top
#371023 - 15/06/2018 18:11 Re: Excel question [Re: BartDG]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31563
Loc: Seattle, WA
I don't know the answer to this, but I know enough about excel to know that it might not have anything to do with your computer's specifications.

I know that Excel has a bunch of heuristics to determine where/when it decides to recalculate a given cell's value, and that the recalculation itself might be slow if the spreadsheet is complicated, for instance if there are a lot of references in the chain of calculation.

Perhaps start here and see if anything rings a bell:
https://docs.microsoft.com/en-us/office/client-developer/excel/excel-recalculation
_________________________
Tony Fabris

Top
#371024 - 15/06/2018 20:51 Re: Excel question [Re: BartDG]
tanstaafl.
carpal tunnel

Registered: 08/07/1999
Posts: 5539
Loc: Ajijic, Mexico
Originally Posted By: BartDF
Any ideas would be appreciated.
If you have a lot of conditional formatting, particularly if the formatting is on cells whose values change based on changes to other cells, this can affect recalculation times.

tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"

Top
#371025 - 15/06/2018 21:48 Re: Excel question [Re: tanstaafl.]
BartDG
carpal tunnel

Registered: 20/05/2001
Posts: 2616
Loc: Bruges, Belgium
Thanks for the response guys. So I guess it's not all that uncommon at all?

Something I have noticed since my first post that might be important : it's indeed a pretty big excel sheet, but when my colleague uses it on his Macbook, this kind of delay doesn't happen. Could it be that Mac is more optimized than my PC for stuff like this?
_________________________
Riocar 80gig S/N : 010101580 red
Riocar 80gig (010102106) - backup

Top
#371026 - 15/06/2018 22:04 Re: Excel question [Re: BartDG]
tfabris
carpal tunnel

Registered: 20/12/1999
Posts: 31563
Loc: Seattle, WA
I believe that the mac and PC versions of excel contain significant differences in their base code and the way they work. I think the differences are more than just "optimization", they may have basic functional differences which mean that recalculation is handled entirely differently.

It also may be a question of configuration settings. Perhaps your installation of excel has something that is configured differently than the default. Can you check the sheet on someone else's Windows machine?

Another question: Is there any chance that the worksheet is referencing any external files, particularly if those files are on a network drive? Or are you opening the file directly from a network drive? Maybe the recalc slowness is a network access issue.
_________________________
Tony Fabris

Top
#371027 - 16/06/2018 04:10 Re: Excel question [Re: BartDG]
Happy Birthday larry818
old hand

Registered: 01/10/2002
Posts: 1033
Loc: Fullerton, Calif.
Launch task manager and see what's burning up the cpu. It probably isn't Excel.

Top