ExcelBanter - CELL("filename",a1) not updating automatically

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CELL("filename",a1) not updating automatically (https://www.excelbanter.com/excel-discussion-misc-queries/185020-cell-filename-a1-not-updating-automatically.html)

FiluDlidu

CELL("filename",a1) not updating automatically

Hi all,

When I save my template file under a new name, I need to complete one
operation before cell i1 (containing the formula mentioned) is being updated.

Anyone knows why this is, or have ideas why it would be?

Thanks for any help,

Feelu

All times are GMT +1. The time now is 08:31 PM.