It's not behaviour I'd expect to see but indeed you are correct:
- Under certain circumstances the Excel data is cleared from the field and an empty cell appears instead when placing Excel data into InDesign.
By default InDesign will import Excel data as an unformatted table, and if this setting is used I can indeed see the text disappear from the cells as you see it.
A work-around for the issue:
- Choose File > Place, select Show Import Options, click select the file and click Open
- In the Microsoft Excel Import Options dialog box, choose either Table: Formatted Only Once, or Table: Formatted Table in the Formatting section.
- Click OK.
In this case the text does appear in the table cells in the tests that I've just done.
The formula that should appear in sheet two is
I sometimes make a second sheet. Mostly I don't. I also (almost) never link to spreadsheets. The screen shot below is a spreadsheet I happened to be using right now. Calculated fields and plain text. And of course ID realized when I flipped back that I had saved what I was doing in Excel...
I don't think I personally have experienced the issue you are having. Does this happen on all spreadsheets or just this one?
If correcting the formulas on a second sheet doesn't fix the problem, and you don't mind sharing the spreadsheet feel free to do so. If so, upload to dropbox.com or the like and, If publicly sharing, post the download link. If sharing privately, PM me the download link.
Thank you! It works!
Perhaps you could advise on my next issue.
Is there a way to format a table, and once I have it the way I like it, select/highlight the table and essentially tell InDesign to make a Table Style based on the selected material? This way I can import my slimmed down data from the excel sheets, highlight the table, and apply the style to it.
Essentially, when the data imports form Excel, it looks like this:
And I am wanting to have the format like this:
Thanks so much for all the help!