Hi and appreciaste your ideas. Unfortunately they didn't solve the problem.
I also thought of the linking issue so I used Excel Options to disable
linking. This failed.

We then disabled every Excel Option in 2007 that somehow could be related.
This failed.

I Copied and Pasted Values over all the linked Worksheets. That failed.

What we've found is that running our application in Office 2007 now requires
0.12 seconds to place a value on any Worksheet.... i.e.
targetsheet.cell.value=x

Okay... what's left. atledreier mentioned some unexpected issues with XL97.
I also remember there were some Worksheets I had at that time when moved
into XL97 contained some hidden characteristics XL97 didn't like - requiring
rebuilding of those sheets. So what we plan to do - pending other ideas - is
to begin to remove older worksheets one section at a time, resave the
remaining system, open again and running a smaple code until we find the
solution.

Again, thanks for your help.

Best Regards, Terry




--
Terry Priebe
Decision Support Associates, Inc
DeSA


"The Dude" wrote:

atledreier made a very good suggestion.

I guess the links must be updated in your new workbook? if not then I
suggest to change the 'Workbook.UpdateLinks' setting (or open the workbook
from a macro with a False attribute to [update links]).

You could also try to add 'Workbook.UpdateRemoteReferences = False' before
the code and '...= True' after the code so that it does not update the links
while running.



"atledreier" wrote:
I had this on an XL97 system once. There was some code running on the
sheet that ran everytime the sheet updated. try enablevents.false and
see what happens...