OFFSET() and save in EXCEL

[Guest]

Hi.
I have made some calculations in an EXCEL workbook. I used 4 sheet with
links between them. If i use the function OFFSET() in a sheet, every time
asked me, Save changes ? without make any changes.
Does anyone know what happen and how fix that problem ?
Th.

 

[Bob Phillips]

Probably because OFFSET is volatile, so Excel thinks it is changed. Try
changing the formula to use INDEX if you can.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)