Back

If your email is not recognized and you believe it should be, please contact us.

  • You must be logged in to reply to this topic.Login

Placing Formatted Table from Excel to CS4 Losing Formatting

Return to Member Forum

  • Author
    Posts
    • January 23, 2011 at 11:41 pm #58468
      ctillyer
      Participant

      I have followed the steps to place a formatted table from Excel to InDesign several times and something keeps going wrong. I use 'show import options' and I select 'formatted table' and I say no to speeding up the process by unformatting it, but my table keeps losing all of its formatting. I don't know what I've done. Is there possible default settings that I've somehow changed so that it keeps overriding my choice of placing the formatted table?

      Any help would be greatly appreciated. (I am a beginner when it comes to InDesign.)

    • January 24, 2011 at 7:19 am #58479
      David Blatner
      Keymaster

      Does it do this with all InDesign documents, or only one?

      When you say “no to speeding up the process by unformatting it” what do you mean? I have never seen anything in InDesign that asks this.

    • January 24, 2011 at 5:19 pm #58491
      ctillyer
      Participant

      It's the default question that pops up after clicking 'ok' in the import options box. “You can speed up the import process by importing the cells as an unformatted table rather than as a formatted table. Do you want to speed up the import process in this way?”

      My boss has since returned from her travels and explained that the formatting had come across okay. The reason it looks like it didn't is because there is a variety of markers in the table (different sized and coloured dots) that InDesign won't bring across to look the same, so I was doing the right thing. It just looked like I'd made a mess of it.

      Thank you for your help. Now I must go and buy a wig, because I've pulled all of my hair out!

    • January 24, 2011 at 8:45 pm #58492
      David Blatner
      Keymaster

      I'm glad it's worked out for you, but… This is a real mystery… I've never seen that alert.

      I wonder if perhaps you have some third-party plug-in installed that you might not realize is running? Are you using DataLinker or some other spreadsheet/database linking software?

    • January 24, 2011 at 8:48 pm #58493
      ctillyer
      Participant

      No, nothing like that. It's a default question with the option to tick 'don't show me this again', so you'll never see it again after ticking it, unless you reset the default questions.

    • January 24, 2011 at 9:10 pm #58494
      David Blatner
      Keymaster

      I guess I'm wrong… I have seen that alert. See our discussion at the very end of podcast 67, where we discuss the obscure indesign feature of the week-eek-eek:

      https://creativepro.com/pod…..script.php

      But I absolutely cannot make InDesign give me that dialog box now — both in CS4 and CS5! How frustrating.

    • January 24, 2011 at 9:14 pm #58496
      ctillyer
      Participant

      That's strange. I am using CS4 and I went into preferences>general and clicked reset all warning dialogues to get it to reappear.

  • Author
    Posts
Viewing 6 reply threads
  • The forum ‘General InDesign Topics (CLOSED)’ is closed to new topics and replies.
Forum Ads