🧠 What’s happening
This is a bug in the code that has been there since we started exporting to Excel templates and not noticed until now.
It seems that Wizard was constantly writing a new screen shot of whatever is there, writes it to ROOFIMAGE.TIF and that becomes the ‘go to image’ for Excel, regardless of what was previously inserted.
So each XL worksheet is indeed dynamically linked to the file ROOFIMAGE.TIF.
Then when you open the document again it grabs the now incorrect ROOFIMAGE.TIF.
🔎 How to confirm it
This is apparent in this example of three different jobs with the report created and at this stage are correct.
Save the reports and then open them again and the image has been switched out with a random image (whatever is currently in the Clipboard).
You may also get this message from Excel:
✅ The fix
The fix is easy - update Roof Wizard to the latest version (Minimum of V10.08b).
ℹ️ FYI (related issue)
FYI - This has also been observed in MS Windows templates when you rotate a plan or Top View of the model.
The fix in that case is to:
Delete the flashings and panels (if applied)
Export the roof geometry as an RXF file [File > Export > RXF]
Import the data [File > New]; then [File > Import > RXF]
Effectively starting the job again, resetting the model datums.