Excel spreadsheet does not work for others

Brentsa

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

sparky2205

Active Member
Joined
Feb 6, 2013
Messages
293
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,365
Office Version
  1. 365
Platform
  1. Windows
In what way don't the formulae work?
 

Brentsa

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,676
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,676
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Yes, the same version can have different functions depending on what actual build has been installed.
 

Brentsa

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows
thanks

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,365
Office Version
  1. 365
Platform
  1. Windows
You could try updating their version, if you IT allows that.
File, Account, Update options.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,422
Messages
5,547,834
Members
410,813
Latest member
Vhinzvirgo
Top