Excel XP links overwhelm Excel '07
First, I admit that I'm using Excel to a rather extreme degree. But what
worked in Excel XP/2002 simply fails in Excel 2007, in spite of my now having
a dual-core screamin' fast machine with 3 gigs of physical memory.
I have perhaps 30 workbooks that are heavily linked (cell references) to
each other, with between 4 and 48 sheets per book. Yes, I know this is many,
that I should just get a database and write queries. BUT: when we upgraded
to '07, I found that trying to save changes took somewhere between 15 minutes
and forever, each time. I got Excel XP installed in parallel, and the same
task is executed, if not instantly, then within the expected several seconds.
I can't stay on Office XP forever (it will cease to be supported), but now
don't see a way forward. Anyone else having a similar problem? Any
suggestions?
|