Issue with iterate table and creating PDF from Excel

Watched PDF reporting process with EasyMorph - Articles - EasyMorph Community - Data preparation professionals and enthusiasts and tried to "replicate" but run into an issue...

I iterate through a table and inserts data to an "Input" sheet in Excel. The sheet "Report" are referncing directly to the "Input" sheet but for some reason the values in the cells are not updated. The workbook is set to automatically calculate and I've even tried the Excel command for "Refresh workbook" with no luck.

Here is a screenshot of how it looks before me doing anything:

As soon as i F2 the cell and hit Enter the correct value is populated:

Dont really know if this is an EasyMorph issue but maybe someone has some hints :slight_smile:

This happens because EasyMorph updates the "Input" sheet, but doesn't update formula results, cached on the "Report" sheet. And Excel shows those cached and outdated results when the workbook is opened. That's expected behavior. But the "Recalculate workbook" command of the "Excel command" action should update the cached values. Can you please double-check that that command isn't working for you?

Double-checked and it does not work, tried "monitoring" each step in the process and opening the actual Excel workbook but it is not updated:

When I open Excel it asks to update connections:

And when I click Update it updates correctly:

So might it be some limitations within Excel? Tried allowing "everything" in the Excel security settings but no change.

I have made a similar example and it doesn't ask me if connections should be updated.

Does your Excel file have external connections or something like that?

And which Excel version you are using?

Version Microsoft® Excel® for Microsoft 365 MSO (Version 2412 Build 16.0.18324.20092) 64-biters.

There is no connections, I tried making a new sheet but its the same - might be some security settings from my 365 tenant..

I have the Excel same version.

Could you switch Excel's interface to English, make that dialog appear again, and share a screenshot? Unfortunately, searching for the original message doesn't yield exact matches, and I need the exact message in English to search for similar issues.

Of course :slight_smile:

I also tried enabling automatic update:

AND - added the folder where workbooks are located to "Trusted location"

Thank you for the screenshot. Also, please run the EasyMorph project that creates that Excel file and send me the created file without opening it in Excel.