Footer date changes from one PC to the next

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

We have created a password protected, spreadsheet on a
shared department drive. When I go into the document, the
date on the footer is different than the same date, in the
same footer, in the same file that another person goes
into. How can this be? We verified it is the same file
by changing some of the data. The data views the same on
both PCs. How can the Header and footer information be
different, viewed on two PCs, in the same file? Thanks in
advance. Ron
 
The date you see is that of the local PC. One (or more) date settings is
incorrect or the PCs could be on opposite sides of the international date
line :-)

HTH
 
1. Check the date is correct in the computer setup.
2. Check Excel Tools/Options/Calculation "1904 date system" is the sam
on both Pcs (the usual setting is to have this un-checked to us
1/1/1900 as base
 
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

Protecting a header/footer 3
Change Header & Footer Info w/ Worksheet Option Buttons 1
How do I make a single header/footer common across all worksheets? 1
Headers and Footers size 2
Protecting Headers and Footers!! 2
Setting up Default Headers/Footers in Excel 3
How to put save date in the header (or footer) 10
Static Date in Header/Footer 3

Back
Top