import external data problem

E

enoakes

I am importing data from ten spreadsheets into oe consolidated one. Five
work, the data appears in the new spreadsheet and updates fine - in the
others some cells (the ones with the most important data) return blank,
refreshing the data makes no difference. Yet where blank cells are returned
the next column works fine.

Help- how do I fix this?

Thanks
 
J

Joel

Check to see if the data is in the column before the ones that are blank. I
would do a Colun Autofit to see all thje data in the worksheet. Select the
entire page by clicking the gray cell betwwh Column a and row 1. Go to
Format Menu - Column - Autofit Selection.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - Importing External Data - formatting problem? 2
Why are some cells returning blank when I import external data? 0
External Data Connections Error 0
Import External Data 3
Import external data into Excel 0
Import External Data Problem 0
2003 - import external data problem 0
#div/0 error 2

Top