Hi Guru,
Question:
Overview: I've multiple sheets in my Excel spreadsheet. I insert date and time in the footer of every page in all sheets.
1. How do I retain the last modified date and time? Each time I open the file. the date and time change even though the file was NOT save. Hence, when I print the current date was printed out in the footer. How do I retain the last_modified date?
2. If the above is not possible to accomplish, I plan to hardcoded the date in the footer. How do I change the date in the footer for all sheets at once? Selecting "Select All Sheets" did NOT work. I still have to change each sheet one by one.
Any help/advice is greatly appreciated.
Thank you.
Jeff (Technical User)
Question:
Overview: I've multiple sheets in my Excel spreadsheet. I insert date and time in the footer of every page in all sheets.
1. How do I retain the last modified date and time? Each time I open the file. the date and time change even though the file was NOT save. Hence, when I print the current date was printed out in the footer. How do I retain the last_modified date?
2. If the above is not possible to accomplish, I plan to hardcoded the date in the footer. How do I change the date in the footer for all sheets at once? Selecting "Select All Sheets" did NOT work. I still have to change each sheet one by one.
Any help/advice is greatly appreciated.
Thank you.
Jeff (Technical User)