Previous Topic Next Topic

Date and F9 Automation URGENT!!

Closed
spauley - Feb 18, 2011 at 05:59 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2011 at 07:00 AM
Hello,
I have a report in EXCEL 2007 that has a master sheet. On the Master sheet I have a DATE field that currently has to be manually updated every day. This date will then populate on another page in the workbook. Once the date is updated to the current date I then manually refresh the data in the report using F9. I am wondering if there is a way to automate this process so that when the report is opened the date with auto update on the master sheet and then auto F9 the data?


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 28, 2011 at 07:00 AM
sounds like your auto calc mode is set to manual. check in excel options
0

Similar discussions

F9 not work
Kimberley -
MaxStart -

3 responses
Corn f9
Frank -
dwebb -

1 response
Toshiba Satellite mouse pad stopped working
wat3755 -
nasir -

218 responses
asus eee pc windows xp factory settings
stonediger -
Ambucias -

1 response
vba error -2147417848 (80010108) automation error
Tbonekiller -
Tbonekiller -

8 responses