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

Image 1
AttachmentSize
Conversion Production Efficiency - Mar.xlsx556.79 KB
Almir's picture

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.

Almir's picture

Could you post file here?

So I can investigate it.

I have uploaded the file

I have uploaded the file

Almir's picture

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

Almir's picture

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.

Almir's picture

Can you send it by e-mail?

Can you send it by e-mail?
almir.budalica@gmail.com

Will do

Will do