How to have HYPERLINK and IMAGE formulas update when re-opening workbooks?

**ultralame** · 02-20-2024, 03:20 PM

I have the same problem with two formulas, IMAGE() and HYPERLINK().

In the IMAGE() case, I have a workbook where I use it to generate QR codes with an external web-based generator. This works fine when I first create the formula.

However, when I close and then re-open the workbook, the formulas are not processed, and the cell says #FIELD! instead of displaying the image. CTRL-ALT-F9 works, but I would like it to load when I open it.

With the HYPERLINK case, it's almost the same, except CTRL-ALT-F9 doesn't work. I have to click into the cell, F2 to be editing the formula, and then RETURN or click out. I have to do this for each cell!

The real problem with this is that I am using an SQL query to generate my data, and that returns HYERLINK formulas. If I use my IDE to run the query and COPY the block of cells from SSMS to Excel, they instantly refresh, but not if I re-open the workbook. If I run the query from within Excel, they come up showing the formula, not the hyperlink. And I need to click-in, edit, click out.

Is there anyway to tell the page to refresh these formulas upon opening?

**DJunqueira** · 02-20-2024, 03:53 PM

Welcome to the forum.

Well, I don't have all this experience with QR cod generators and SQL, but another day I did something with IMAGE() and HYPERLINK() formulas that may apply here, I used PQ to create Data Type and from that stable clickable hyperlinks.
The file is attached for inspirational purpose.