Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import file to excel
I have a report that's imported into excel and the data begins on row 4.
There's data in rows 4-7. Rows 8-11 are blank and the remaining rows contain data. Here's my problem...When I import using the pc the excel file was created on the data is imported as stated above. When i import using another pc, rows 8-11 that were blank now contain the data that should be in rows 12, 13, 14, 15, etc... it's like rows 8-11 were deleted and the data was shifted up. Anyone know why the report would import differently using another pc? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import file to excel
there could be a number of reasons.
1) Is the file a CSV. If so open the file using Notepad a look at the data on the 2 PC's. Post the data so we can see what it looks like 2) Maybe there were rows hiddin on one of the PC's before theh data was imported 3) Maybe there was an autofilter set on the worksheet before the data was imported. 4) Was a macro used to import the data. Post the macro. "Peruanos72" wrote: I have a report that's imported into excel and the data begins on row 4. There's data in rows 4-7. Rows 8-11 are blank and the remaining rows contain data. Here's my problem...When I import using the pc the excel file was created on the data is imported as stated above. When i import using another pc, rows 8-11 that were blank now contain the data that should be in rows 12, 13, 14, 15, etc... it's like rows 8-11 were deleted and the data was shifted up. Anyone know why the report would import differently using another pc? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import file to excel
The file type is unknown. It's created by a program called Health Axis. Using
notepad on three pc's the data looks the same except for one of the pc's (A pc I don't use). The spacing is a different. It's the same on the pc I normally use (imports correctly) and on the another pc it's also the same but does not import correctly. I did notice that even thought both pc's have excel 2003 the versions are different. I'm going to see if that has an impact on how the file is imported. Thanks!!! "Joel" wrote: there could be a number of reasons. 1) Is the file a CSV. If so open the file using Notepad a look at the data on the 2 PC's. Post the data so we can see what it looks like 2) Maybe there were rows hiddin on one of the PC's before theh data was imported 3) Maybe there was an autofilter set on the worksheet before the data was imported. 4) Was a macro used to import the data. Post the macro. "Peruanos72" wrote: I have a report that's imported into excel and the data begins on row 4. There's data in rows 4-7. Rows 8-11 are blank and the remaining rows contain data. Here's my problem...When I import using the pc the excel file was created on the data is imported as stated above. When i import using another pc, rows 8-11 that were blank now contain the data that should be in rows 12, 13, 14, 15, etc... it's like rows 8-11 were deleted and the data was shifted up. Anyone know why the report would import differently using another pc? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
import file so that it is a actual csv file, no excel cell version | New Users to Excel | |||
import data from txt file to an existing excel file | Excel Discussion (Misc queries) | |||
How come I can't import an .svc file(Open Office) to Excel file? | Excel Discussion (Misc queries) | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming |