I create a link in my InDesign doc to an excel book, pulling in 5ish cells containing a calculated value.
The excel sheet changes, and InDesign detects a change as normal.
However when I update the link the content just disappears. If i re-place a fresh link the data appears correctly until the next change again.
Any Idea as to how i can fix this issue?
After searching some more i found this thread Re: InDesign doesn't import .xlsx correctly. Any idea is welcome!
I found that importing 'unformatted' from .xlsx didn't work as intended.
I decided to re-save my workbook to .xls which imports much better to InDesign
This method resolved my issue.