Skip to main content
C
camelbreath
Inspiring
July 19, 2023
Question

Excel formatting not coming in with file placement

  • July 19, 2023
  • 2 replies
  • 442 views

I placed an Excel 365 file in InDesign (up-to-date) and the every-other-row background colors did not come with the placement. I did the every-other-row colors with an Excel formula I found on You Tube. Any ideas on what went wrong?

Thanks to those who know more than me,

Joe

    This topic has been closed for replies.

    2 replies

    BobLevine
    Community Expert
    BobLevineCommunity Expert
    Community Expert
    July 19, 2023

    Bill's answer is correct, but typically you're going to be prompted for that whether you select show options or not. Selecting formatted table should work for most formatting.

     

    What I don't quite understand is what you mean by "I did the every-other-row colors with an Excel formula I found on You Tube."

     

    What does that mean?

    Robert at ID-Tasker
    Robert at ID-Tasker
    Legend
    July 19, 2023

    In case of a formula and not a macro - conditional formatting. 

     

    BobLevine
    Community Expert
    BobLevineCommunity Expert
    Community Expert
    July 19, 2023

    I was thinking that, too, and I'm not sure InDesign can read that.

    Bill Silbert
    Community Expert
    Bill SilbertCommunity Expert
    Community Expert
    July 19, 2023

    When you place the excel file using File>Place make sure that Import Options is checked in the Place dialog window that appears. When you then choose the Excel file you will get the Microsoft Excel Import Options dialog window. There you can use the pull-down menus in the Formatting area to make sure that any styles established in the Excel file will be imported.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices