1 person found this helpful
What version of InDesign? What version of Excel? What operating system?
Thanks for the reply.
Sorry, showing my lack of forum experience there.
I'm working on a mac.
Mac OS: Yosemite 10.10.5
I've tried it in both InDesign CC 2015 and CC 2017. Using InDesign CS6 is not an option we can use either.
Not completely sure what version of Excel it's been created in as it's been supplied to us but we have both here: 15:34 for Mac and 2016 for PC if i need to work on the Excel file itself.
2 people found this helpful
How are you placing the files? Named range? Actual range? Formatted Table? Unformatted table? Are you creating a link to the Excel file?
The Master Excel file has named ranges.
These named ranges are placed into InDesign and a link is created.
We are using 'Wordsflow' to retain styling when updating the link.
I had been using the 'Unformatted table' option as we were just applying our formatting over the top once the file was in InDesign and i didn't think that would be the problem but after you asked the question i thought i should doublecheck that and hey presto, the content came through.
I styled it up and updated the link with a modified version just to make sure the formatting didn't blow out and it didn't.
I definitely need to test this further but i think it looks like it's solved the problem. Still don't know why 'Unformatted table' would blow out the dynamic content but if this proves then answer then i guess it doesn't matter.
Fantastic Bob, you are a superstar!
Always helps to bounce stuff off of someone else
Thank you for your help!
I think i tried that early on, when i first encountered the problem but thanks for the link and i'll doublecheck just to be sure and post on there.
Thanks again for your help. Much appreciated.
Thanks for the details. I've marked your answer as correct so that others with similar issues can get benefited from this post.