dates in excel

  • Thread starter Thread starter pentex
  • Start date Start date
P

pentex

hi all
need help with the date function
this is the situation
i use excel daily to create a report. as this report is
printed out i just save changes made.
except at the weekend when i also make backups so that my
boss can send the report by email on monday mornings.
in the report we use the NOW function to display the date.
when we used to open the backups the date never used to
change ie if saturdays backup was opened on monday morning
it used to still display saturdays date.
now for some reason the date is automatically updating.
anybody know how to prevent this happening
 
You probably had the Manual checkbox checked in
Tools/Options/Calculation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Formula Help!! 6
Date formula/help 4
Date Questions 1
Number of Hours&Minutes between Dates and time 2
formual to determine if date falls on weekend, adjust date to Mond 4
Merge Multiple workbook sheets into one workbook 0
validate a date range 4
Date + X days excluding holidays 1

Back
Top