Why are some cells returning blank when I import external data?

E

enoakes

I need to consolidate a certain sheet from a number of different workbooks
into separate sheets on a new 'consolidated' workbook. I have used
Data>Import External Data, and for half of them this is working fine.

My problem is that on the other sheets that the data has been imported to
some of the cells are coming up blank when there is data in the original.

Is there any way to fix this? Please help!
 

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

Import data into protected worksheet 0
Delete certain text from cells 2
reverse pasting rows with alternate blank cells 0
import multiple excel books to one excel workbook 3
import external data problem 1
How to manage new data with external data in Excel? 1
Publisher is filling blank lines with data 2
Import External Data 3

Top