Excel spreadsheet does not work for others

[Brentsa]

Good day,

Our work make use of Office 365 Pro Plus, I've created a spreadsheet with load of formulas to assist with the verification of individual person's work for the day. The spreadsheet works 100% on my PC. But the minute any other user makes use of the spreadsheet on their PC the formulas does not work and therefore the spreadsheet does not work.

I do not understand what the issue is. Can anyone assist me?

Thanks

 

[sparky2205]

One simple thing you can check is that the calculation method is set to automatic for the other users.
Formulas -> Calculation Options -> Automatic
This is set for each incidence of Excel. So it could be automatic on your PC but manual on another users.

 

[Brentsa]

One simple thing you can check is that the calculation method is set to automatic for the other users.
Formulas -> Calculation Options -> Automatic
This is set for each incidence of Excel. So it could be automatic on your PC but manual on another users.

Looked at this and even tried to do a calculate now option on thier PC but nothing. The spreadsheet seems to only work on my PC. There are no external links either, all the formulas relate to data in the spreadsheet itself.

 

[Fluff]

In what way don't the formulae work?

 

[Brentsa]

I've now sat at another persons desk.

My original formula: =FILTER('STD TellerStatisticsHistoric'!$B$1:$R$5000,'STD TellerStatisticsHistoric'!$B$1:$B$5000=Teller!A1,"")

The formula that appears on their PC: {=_xlfn._xlws.FILTER('STD HistoricOrderSummary'!$A$1:$I$1000,'STD HistoricOrderSummary'!$E$1:$E$1000=A1,"")}

When I try to change the their formula is states I cant change it.

 

[RoryA]

That means they don't have the FILTER function available. If they're on 365 they are on a slower release channel than you are.

 

[Brentsa]

That means they don't have the FILTER function available. If they're on 365 they are on a slower release channel than you are.

even if it means we on the same version?

 

[RoryA]

Yes, the same version can have different functions depending on what actual build has been installed.

 

[Brentsa]

thanks

Any idea on how to change the filter formula for something else for a older version?

 

[Fluff]

You could try updating their version, if you IT allows that.
File, Account, Update options.