Excel Spreadsheet On Shared Drive Showing Different Results On Different Computers

[Jesbass]

Hi all. This has me absolutely baffled.

I've created a bunch of spreadsheets on a shared network drive. These spreadsheets download data from an external party (and this always works fine). A separate worksheet accesses this downloaded data to fill relevant fields, HOWEVER...

While it generally works fine on my computer, other people in my department accessing the same spreadsheet encounter #REF! errors for some or all of the data.

Is there an obvious setting that I should be checking, in case I've set it up wrong, somehow?

 

[Michael M]

Are they either
1. Deleting columns / rows/ cells that contain data relative to formulas in that worksheet ?
2. have pasted cells that you moved over the top of cells that were referred to by other formulas ?

You could also have a read through this thread, which may help...


Excel linked data formula turns to #REF upon opening workbook - Super User