Thanks for the quick response – do I save the excel in a certain format? I’m not having any luck; when I save the excel and import it into inDesign I cannot modify the imported info. Any thoughts on that?
No idea. When I import exel into InDesign, I get an editable, formattable table. If the file is something you can share, you could upload it to usendit or another file-sharing service and post the link here. I or someone else here could take a look.
Are you using copy>paste to get the excel info into InDesign? That is the only way I could replicate your problem.
From your InDesign document, go to the File menu, and chose Place. Be sure to check the box for Show Import Options, and choose Formatted Table. that will get you the result you need.
Please let me know if this works for you.
File>place is the way all content from other applications should be added to InDesign. Save copy>paste for moving things from one InDesign document to another, or one page to another.
I'm glad I was able to help.
I was trying the "place" option, using the instructions above. The "paste" option doesn't bring over any of the grid lines - unless I am missing something, which is entirely possible!!
The cells are formatted in Excel how we want them. It is basically a table/chart of tool sizes and diameters that I wanted to get into InDesign so we can do layouts for our formal catalog.
I have tried formatted, unformatted and formatted only once options and I still get the red dots.
Bob - Is it safe to assume there is really nothing I can do other than copy and paste the info and just have to mess with the grid lines some other way?
I'm having the same issue, where after I place the formatted excel doc into Indesign, I get a red dot and no data. The excel file I'm trying to place is directly exported from Quickbooks Enterprise Solutions. I've tested placing other excel docs and they seem to work fine. Any Ideas why export from Quick books isn't working? Thanks.
I have succesfully placed my formatted table in to id, but the purpose of it is for an invoice, so i need values of the table to be editable in an interactive PDF e.g quantity and price, so that a total will be calulated.
Is there a way to make this table interractive?
ive tried exporting and formatting in different ways but to no avail
can anybody help?
You’d have to create the proper fields. This is a bit outside my area of expertise but I have done this in the past.
But…I did the final work in Acrobat pro to add the calculations.
BTW, this has nothing to do with placing a formatted table from Excel. You’ll need to create the table and then add the text fields.