Pivot table showing two different results when opened on different computers
Hello,
This is my first post and really hoping someone can shed some light on this problem.
I have a Pivot running on an Excel 2007 spreadsheet using the 1904 date system as it deals with negative times.
The pivot works fine on my computer per top screenshot
When a colleague opens the spreadsheet and updates the Pivot it gives out some ridiculous figures (second screenshot). I can only imagine the problem lies in the use of the 1904 date system or some options that I have enabled but my colleague has not.
Can anybody help!!!
Thanks
Martyn
Attachment | Size |
---|---|
Conversion Production Efficiency - Mar.xlsx | 556.79 KB |
Did your colleague change date system in Excel to 1904?
Did your colleague change date system in Excel to 1904?
Hi Almir, The date system is
Hi Almir,
The date system is attached to the spreadsheet so from his computer it is telling me 1904 is selected.
Could you post file here?
So I can investigate it.
I have uploaded the file
I have uploaded the file
I can not open the file
It says: file format is not .xlsx.
Can you please check?
I can confirm the properties
I can confirm the properties state it is an .xlsx
Could you save it with different name?
I constantly receive error message: it is either corrupted, or in different format than .xlsx.
It opens fine on excel on all
It opens fine on excel on all PCs here. I even downloaded the link from this site and it still opens.
Not sure how else to get the file across.
Can you send it by e-mail?
Can you send it by e-mail?
almir.budalica@gmail.com
Will do
Will do