I’m sure I read something about this somewhere, sometime, but damned if I can figure out where.
My Excel installation has suddenly decided that it’s going to pause every minute or two, go through a monstrous flurry of network activity (locked during that time frame), then return to normal. Similarly, certain formatting functions immediately cause a flurry of network activity (and locking up of the machine).
These are locally saved files, and I don’t see anywhere in Excel anything pointing to an external data source.
I haven’t lit on a Google search that doesn’t return over a million hits based on the terms given. Anyone have any ideas?
138 view(s)
Ummm…
It’s a feature?
Which version of Excel? Office 2003?
You could have a hidden table doing a look up for something that it can’t find so it goes out to the network to find it.
Yes, 2003.
Well, at least one spreadsheet of the recent flock I’ve been working with has references originally from another one — but it’s local, too, and I told it not to do updates anyway. Still, I can poke at that a bit.
There’s a way to sever those connections, but I don’t recall what it is.
You may want to check your formulas — one of them may be making excessive, recursive calculations. Look for “matrix” or “array” formulas, which are set up with curly brackets. See also below:
http://www.stanford.edu/~wfsharpe/mia/mat/mia_mat4.htm
As for outside tables, change to formula view (ctrl-` — the mark under the tilde) and do a search for “!” which should show you any links to other docs or spreadsheets. Actually, do this first, eh?
Duh…it’s been so long since I did anything significant with Excel it’s like I’m remembering legends I heard at my grannie’s knee…