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 |
Solved
Hi Martin,
I encountered the same problem upon opening the file. I see the same ridiculous figures in pivot table.
However, I think the problem is in formatting of the time cells in pivot table.
Change format of time cells in pivot table to : hh:mm:ss - instead of: [h]:mm:ss.
That should solve your problem.
Regards,
Actually, format "[h]:mm:ss" is used for time longer than 24 hours.