: Data missing when importing a spreadsheet into InDesign I am currently having a bit of a delima importing excel spreadsheets into InDesign. The spreadsheets in question use formulas to pull data

I am currently having a bit of a delima importing excel spreadsheets into InDesign.

The spreadsheets in question use formulas to pull data from other spreadsheets on the network (using vlookup) - currently set as, Part Number (Alpha-numeric, Description (Paragraph), case qty. (number), Price (currency).

When importing the spreadsheet (using File > Import), it imports everything correctly, including the headers; except for the description paragraphs.

I am currently using ID5.5 and the spreadsheets are .xlsx

Is it a bug with InDesign? Am I doing something wrong?

10.02% popularity Vote Up Vote Down

: Designing High Resolution Mobile SplashScreens? How do you get those stunning splash screens / launch screens for mobile apps? I have tried setting the canvas in Photoshop to be the same pixel

@Heady304

Posted in: #AdobePhotoshop #Mobile

1 Comments

: Simulate foursquare ripple icon effect I need help simulating this effect in Adobe Illustrator, but with a different logo, which is also based on stroke. I've tried blending the logo with another

@Heady304

Posted in: #AdobeIllustrator #Stroke #Vector

1 Comments

: Sketchup How To Create Two Rectangles and Stack Them on Each Other Without Being Sticky and Distorting and Locking Together? DESCRIPTION: I'm new to Sketchup and I'm following the Lynda.com SketchUp

@Heady304

Posted in: #Autocad #Sketchup

1 Comments

: Big clear sticker for shop front window - advice Having a new job to do which is a big illustration, 1200mm X 2400mm high for a shop front window to be printed onto clear vinyl, a big sticker.

@Heady304

Posted in: #PrintDesign #Resolution #Vinyl

1 Comments

Login to post a comment!

2 Comments

Sorted by latest first Latest Oldest Best

@Tiffany317

After doing several tests, I had a hunch that ID5.5 might not be compatible with new excel files (with the .xlsx extension). So I saved my excel spreadsheets with the earlier 2007-2013 version (.xls), and long and behold, it imported the data as desired.
I hope that this little tip might help someone who might be having a similar issue.
TIP OF THE DAY: Always check for software/document compatibility.

10% popularity Vote Up Vote Down

@Angela777

Try this

Select "Place" from the File menu. Select "Import Options" and double-click the Excel file containing your spreadsheet. The Import Options dialog box opens. Click the "Sheet" menu and select the worksheet from the Excel workbook that you want to import

10% popularity Vote Up Vote Down

Feed

: Data missing when importing a spreadsheet into InDesign I am currently having a bit of a delima importing excel spreadsheets into InDesign. The spreadsheets in question use formulas to pull data

More posts by @Heady304

: Designing High Resolution Mobile SplashScreens? How do you get those stunning splash screens / launch screens for mobile apps? I have tried setting the canvas in Photoshop to be the same pixel

: Simulate foursquare ripple icon effect I need help simulating this effect in Adobe Illustrator, but with a different logo, which is also based on stroke. I've tried blending the logo with another

: Sketchup How To Create Two Rectangles and Stack Them on Each Other Without Being Sticky and Distorting and Locking Together? DESCRIPTION: I'm new to Sketchup and I'm following the Lynda.com SketchUp

: Big clear sticker for shop front window - advice Having a new job to do which is a big illustration, 1200mm X 2400mm high for a shop front window to be printed onto clear vinyl, a big sticker.

Login to post a comment!

2 Comments

Back to top | Use Dark Theme