Importing External Data doesn't work for some users!?

  • Thread starter Thread starter Toby Erkson
  • Start date Start date
T

Toby Erkson

Okay, I have a very simple workbook that pulls external data. The data
comes from the company's reporting server which is exported as an .xls file.
Nothing fancy. My workbook pulls that .xls file in using Import External
Data (initially started using the wizard) and I've left all the defaults
alone. Nothing fancy.

Now, when my workbook is opened on my computer the import is successful and
I see the first column and it contains company names and the following 3
columns contain numbers. I see everything I'm supposed to. Nothing fancy.

When I open the same workbook on another user's computer the import is 1/2
successful. By this I mean the column with the company names imports just
fine but the following 3 columns that contain numbers do not show up!

Both computers are running Excel 2003, SP1 on XP with the same add-ins
installed. This has got me totally baffled!
 
You might want to also check to see that both have the same reference
set in the VB project. (Alt+F11 ->Tools->References
 
Borrowed from Gord Dibben's reply to another post:
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp>/e if
you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP
Click to expand...

I just checked the file name association and they are the same on each
computer. Still need help... :-(
Toby
 
Bump. Anyone?
Toby

Toby Erkson said:
Borrowed from Gord Dibben's reply to another post:
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp>/e if
you want Book1 to open.

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP
Click to expand...

I just checked the file name association and they are the same on each
computer. Still need help... :-(
Toby

Toby Erkson said:
Okay, I have a very simple workbook that pulls external data. The data
comes from the company's reporting server which is exported as an .xls file.
Nothing fancy. My workbook pulls that .xls file in using Import External
Data (initially started using the wizard) and I've left all the defaults
alone. Nothing fancy.

Now, when my workbook is opened on my computer the import is successful and
I see the first column and it contains company names and the following 3
columns contain numbers. I see everything I'm supposed to. Nothing fancy.

When I open the same workbook on another user's computer the import is 1/2
successful. By this I mean the column with the company names imports just
fine but the following 3 columns that contain numbers do not show up!

Both computers are running Excel 2003, SP1 on XP with the same add-ins
installed. This has got me totally baffled!
Click to expand...
Click to expand...
 
Well, couldn't figure it out so the workaround was to open the .xls file,
Save As... a .csv file, and import that into the workbook.
Toby
 
Back
Top