You can start with some real details. What does "some of the data does
not follow" mean?
The 2010 Excel table has data in every cell.
Once imported, some of the cells are empty, i.e. the data has disappeared.
Is this clearer?
Still not really clear enough. You say you're "importing" the table...does that mean you're using File > Place?
It's possible the cells that are coming up empty don't contain discreet values. Might they contain formulas, functions, links, etc.?
I’m sorry, my application is in French so I am trying to translate as best I can.
Yes, I use File / Place option to import the Excel table into In Design.
The data in some of the Excel cells disappears once into InDesign.
Sorry again, didn’t see the next sentence.
Yes, they do contain links and/or formulas.
The thing is, the problem is recent, i.e. we’ve been using this method for a couple of years now and it is only now that we are having problem with the data.
Sounds like it may be overset. Do you see a red dot in the cell?
No, it’s not overset.
There were no red dots in the cells and I even tried backspacing just in case…
Try to save to older version (Excel 97-2003)
Yes, I have tried that but it does not work.
Thank you for the suggestion though.
Okay then, getting back to the contents of the offending cells: I don't do a lot of placing spreadsheets, so I don't have much experience upon which to draw, but knowing something about Excel, it's certainly conceivable that a cell can contain compound functions and dependencies which might choke InDesign's Place capabilities. And, I assume you're not content just saying "it always worked and now it doesn't," so what if you try a copy > paste [values only] in a clean spreadsheet? Will that Place successfully?
That would be a solution of sorts.
The thing is that the tables have to be updated regularly in ID so I just cannot see myself copying and placing (values only) every single time the finance manager changes a number in a cell in the Excel table.
But it is a solution for the final version of the report, yes.
Still, I’d like to fix the problem.
Me thinks it’s because the Excel file is full of tabs with links and such and maybe we just reached the maximum InDesign can handle and that is why it worked before and now it doesn’t.
I don’t relish having to explain that to the finance manager though. That’s why I’m looking for a solution because the option of starting a brand new Excel file is just not possible.
Thank you for your help!
I understand. Actually, I wasn't offering the clean sheet thing as a solution...more of an experiment to see whether it makes a difference. There may be ways of cleaning up that Excel file to make it work more reliably, further into the future.