Excel spreadsheet does not work for others

Brentsa

Board Regular
Joined
Oct 3, 2013
Messages
118
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
 
If you cannot update Excel for the other users, post back & I will give you another formula, but it's going to be significantly slower than your formula.
 
Upvote 0

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
If you cannot update Excel for the other users, post back & I will give you another formula, but it's going to be significantly slower than your formula.

It would help to have a different formula.
 
Upvote 0
Ok, which cell are you putting the formula?
 
Upvote 0
Im putting this in cell A2 on a new sheet:
=FILTER('STD TellerStatisticsHistoric'!$B$1:$R$5000,'STD TellerStatisticsHistoric'!$B$1:$B$5000=Teller!A1,"")
 
Upvote 0
Ok how about
Rich (BB code):
=IFERROR(INDEX('STD TellerStatisticsHistoric'!B$1:B$5000,AGGREGATE(15,6,(ROW('STD TellerStatisticsHistoric'!$B$1:$B$5000)-ROW('STD TellerStatisticsHistoric'!$B$1)+1)/('STD TellerStatisticsHistoric'!$B$1:$B$5000=Teller!$A$1),ROWS($A$2:$A2))),"")
dragged down & across.
If your putting it on the Teller sheet, remove the part in red.
 
Upvote 0

Forum statistics

Threads
1,213,490
Messages
6,113,957
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top