Workbook not opening the same for everyone

[benotijc]

I hope I will be able to get some assistance with this issue.
What going on is that the organization i work for has a workbook sent out that pulls in all the interval information for the next 14 days.
This workbook works fine for most users.
but we have a few that are unable to view the data it only populates zeroes. If the user previews the workbook in Outlook with out opening they see all the proper content.
But as soon as excel opens the document the values appear briefly then vanish in to "0".
At first i thought it maybe isolated to that user. but i tried the workbook on my account on a different workstation and it has the same issue.
Is their a way i can force excel to populate the values?
I have tried enabling macro content. running them manually no luck so far.
Or is there a way i can compare my excel settings on one pc thats working properly to those who are not?

[Richard Buttrey]

Hi,

Are the workbooks being opened by clicking the filename in the Outlook email, or by first saving the email attachment and then opening it from the saved location?

[benotijc]

I have tried both ways of double clicking straight from outlook. and by saving the document to the pc.
For the users that the content works both methods work the same.
And for those who do not work they get the same result just different values.

[popipipo]

What formulas are used?
What is the celformaat of these cells?
Or upload a small sample file

[benotijc]

Hello,
The only macro formula is:
Sub auto_open()
On Error GoTo Errhandler
Sheets("Paste").Select
Sheets("WL Loyalty").Select
Range("C8:F8").Select
ActiveCell.FormulaR1C1 = "=TODAY()+1"
Range("C8:F8").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("RunRates").Select
ActiveSheet.PivotTables("ICRollup").PivotCache.Refresh
Sheets("Paste").Select
Exit Sub

Errhandler:

End Sub
As for formatting the documents that work and don't are formatted the same.
I also attached a small one page sample of the document.

[popipipo]

Sometimes it goes wrong with celformaat 'mmmm' or 'MMMM'
Excel sees mmmm as minutes and not as month.
But I don't see this in your file

I don't know what or why it goes wrong.