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

Similar discussions

Turn on keyboard backlight Acer Aspire Lite
naveen -
HelpiOS -

4 responses
HP Function F9 key not working
Rajiv -
mysterry60 -

1 response
Acer Aspire 3 activate the keyboard light
Caroline -
djhfhj -

5 responses
how to reinstall or factory reset an asus x202e
binkeyboo1121 -
xpcman -

1 response
Does Acer Aspire have a backlight keyboard?
batang-akrho1973 -
HelpiOS -

1 response