OFFSET() and save in EXCEL

  • Thread starter Îικος
  • Start date
Î

Îικος

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.
 
B

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)
 
Top