I have an open workbook collecting data from anoher source upon either
autosave while editing (meaning I manually change an insignificant cell) or I
manually hit F9 (Calc Now). I would like it to automatically update
(Calculate the workbook). I have a module setup which is saving the workbook
automatically without edit, but this doesn't update the data (like Calc Now
does) (i.e. if I put the function NOW() in a cell on a worksheet, it returns
the current date and time. In order to see the time updated you must hit F9
or in Autosave mode, update any cell and upon autosave, it will update). Is
there code to immulate the F9 key being hit, without any manual intervention.
I'd like the workbook to update and save at pre-defined intervals all by
itself. Please help with update (calculate workbook function). It is my
intention to have this workbook updating and saving 24 hours a day, seven
days a week, 365 days a year (all by itself).

Thanks in advance for your help!
Liz

Hi Liz

Have you tried:
application.Calculate

Regards
Rowan

Liz L :) wrote:
I have an open workbook collecting data from anoher source upon either
autosave while editing (meaning I manually change an insignificant cell) or I
manually hit F9 (Calc Now). I would like it to automatically update
(Calculate the workbook). I have a module setup which is saving the workbook
automatically without edit, but this doesn't update the data (like Calc Now
does) (i.e. if I put the function NOW() in a cell on a worksheet, it returns
the current date and time. In order to see the time updated you must hit F9
or in Autosave mode, update any cell and upon autosave, it will update). Is
there code to immulate the F9 key being hit, without any manual intervention.
I'd like the workbook to update and save at pre-defined intervals all by
itself. Please help with update (calculate workbook function). It is my
intention to have this workbook updating and saving 24 hours a day, seven
days a week, 365 days a year (all by itself).

Thanks in advance for your help!
Liz

It is not clear whether you want to automate the workbook beging
recalculated or updated from the other source.

If the former, I assume you have calculation set to 'manual.' Either
set it to 'automatic' or check 'recalculate before save.' (Tools |
Option... | Calculate tab).

If the latter, depending on how you are getting the external data, there
is probably an option to 'update before save' or 'update on open.'
Check one (or both) of them.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
I have an open workbook collecting data from anoher source upon either
autosave while editing (meaning I manually change an insignificant cell) or I
manually hit F9 (Calc Now). I would like it to automatically update
(Calculate the workbook). I have a module setup which is saving the workbook
automatically without edit, but this doesn't update the data (like Calc Now
does) (i.e. if I put the function NOW() in a cell on a worksheet, it returns
the current date and time. In order to see the time updated you must hit F9
or in Autosave mode, update any cell and upon autosave, it will update). Is
there code to immulate the F9 key being hit, without any manual intervention.
I'd like the workbook to update and save at pre-defined intervals all by
itself. Please help with update (calculate workbook function). It is my
intention to have this workbook updating and saving 24 hours a day, seven
days a week, 365 days a year (all by itself).

Thanks in advance for your help!
Liz

That was it. Thaks for the expertise!

Liz

"Rowan Drummond" wrote:

Hi Liz

Have you tried:
application.Calculate

Regards
Rowan

Liz L :) wrote:
I have an open workbook collecting data from anoher source upon either
autosave while editing (meaning I manually change an insignificant cell) or I
manually hit F9 (Calc Now). I would like it to automatically update
(Calculate the workbook). I have a module setup which is saving the workbook
automatically without edit, but this doesn't update the data (like Calc Now
does) (i.e. if I put the function NOW() in a cell on a worksheet, it returns
the current date and time. In order to see the time updated you must hit F9
or in Autosave mode, update any cell and upon autosave, it will update). Is
there code to immulate the F9 key being hit, without any manual intervention.
I'd like the workbook to update and save at pre-defined intervals all by
itself. Please help with update (calculate workbook function). It is my
intention to have this workbook updating and saving 24 hours a day, seven
days a week, 365 days a year (all by itself).

Thanks in advance for your help!
Liz

You're welcome.

Liz L :) wrote:
That was it. Thaks for the expertise!

Liz