I keep receiving a value error on my worksheet for several cells. I am able to fix it for myself by shortening the reference cells but the folder is a shared folder and it causes everyone else to have an error.
Initially i thought it was the drive mapping but i realized it maybe because all my colleagues are using older versions of Excel (I am using 365).
I was able to view it using the file the file-browse method but when i saved it everyone else started seeing the #value error
How do i fix this?
