View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
booner booner is offline
external usenet poster
 
Posts: 4
Default Disabling effects of cells (temporarily)

I have an odd situation (odd to me anyway) - getting some information from a
database via a macro. The spreadsheet is quite large (many worksheets) -
and when the information is taken from the database and put into the
spreadsheet it is very slow. I tried this same code in a blank spreadsheet
and the performance was very good. So my thought is - the effect of putting
the data into this worksheet (and then Excel updating all of the
worksheets - is the performance problem) - so I was curious if there is a
way to put the data into this worksheet - and disable the effect in Excel of
updating all of the references to this worksheet (cells) - until the
database transaction is complete.

Am I crazy?

BBB