Calculations on Pause due to new Script/Macro?
Hi!
I got a great macro/script workbook to download historical stock prices. I copied the 2 sheets and placed them in front of my Stock Anayzer Workbook. The script still works great but when I copy & paste the imported data, no calculations are occuring in my Stock Analyzer Sheets. Not even simple reference ones like: =$E$2. I'm a noob to VMB and Macros. Do I need to put it back in Run mode or something. The funny thing is when I save the compilation then the calculations update. Strange days in cyberspace. Any help is appreciated. Thanks
Last edited by stockgoblin42; 06-24-2011 at 10:22 AM.
You probably just have manual calculation turned on (if everything updates when you press F9, you have).
Go to options > calculation > automatic and you should be good to go.
Yea, Calculations were switched to Manual somehow. Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks