LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default Iterate upon opening - DA

I have received an EXCEL file and, whenever I open it, it changes the
calculation mode into iterate, even though it has no need for such.
Regardless of whether there is a need or not, I am having trouble
locating the source of this action, which I'd like to defeat. There
seem to be no "do this upon opening" macros listed anywhere, in fact
no macros at all. The This workbook tab is empty and there is only
one oter item listed: Sheet1(summary). Can someone list the places
such a macro could be hiding? Or any other way this could be
happening?

Here's some clues, maybe: On Sheet1(summary) in VBE, I notice that
"enable calcualtion" is set to True. If I change it to false, resave
the file, and reopen, the problem goes away, although I notice that
the enable calculation is back to True again (maybe it's a toggle).
Though that does seem to fix the file, I'd still like to know how it
got set to iterate to start!

This does not happen with my other files.

Thanks much for any help
Dean
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Iterate combo box inungh Excel Programming 5 December 18th 08 12:27 PM
iterate my rows rodchar Excel Programming 2 November 7th 08 07:27 PM
Iterate Thru Cells Kelvin Excel Programming 4 September 5th 07 10:18 AM
Iterate through a form RobEdgeler Excel Programming 2 September 17th 05 06:58 PM
Can't iterate thru a row with For peter Excel Programming 2 January 7th 05 04:46 AM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"