Hi all,

i hope someone might be able to help...i work with few excel sheets at a time, linking one to another etc. Other people in the office do the same and we all use and share most of the spreadsheets. When i open a spreadsheet (let me call it 1) that i have linked to data in spreadsheet 2 few days ago, I get these #REF errors. I think that this keeps happening because someone else opens this spreadsheet 2 in meanime and saves it. I can't fix by going to 'update links'. I'm not sure if this is why it keeps happening though (i just think it might be that). Does anyone know why this is and how it can be fixed?

Thank you