Troubleshooting Data Import from Excel File


H

HolyGeneralK

Hello all!

I am trying to determine why my data import into excel 2002 is not
working correctly. I have multiple Excel sheets that I am going to
have feeding into one primary one. One sheet I have imported
correctly; although its formatting got shot to hell in the process, it
is still usable and workable.

However, I run into problems with a second sheet. When I do the data
import from the other excel file, I can see the titles for both
columns and rows, but no numerical data. This happens with another
worksheet from the same workbook.

In the excel workbook that I am trying to import from, I notice that
it is read-only. Is this the root cause of my problem? I cannot
understand why it would be - all I am doing is reading data from that
other workbook, not writing to it.

Can someone please help?

Thank you!

-Kevin Kennedy
B/E Aerospace
 
Ad

Advertisements

H

HolyGeneralK

Hello all!

I am trying to determine why my data import into excel 2002 is not
working correctly. I have multiple Excel sheets that I am going to
have feeding into one primary one. One sheet I have imported
correctly; although its formatting got shot to hell in the process, it
is still usable and workable.

However, I run into problems with a second sheet. When I do the data
import from the other excel file, I can see the titles for both
columns and rows, but no numerical data. This happens with another
worksheet from the same workbook.

In the excel workbook that I am trying to import from, I notice that
it is read-only. Is this the root cause of my problem? I cannot
understand why it would be - all I am doing is reading data from that
other workbook, not writing to it.

Can someone please help?

Thank you!

-Kevin Kennedy
B/E Aerospace

UPDATE: I have decided to use a workaround by directly linking the
cells necessary
 

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

Top