Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a nice book set up with web querys and it's doing a fantastic job for me, except for one little problem: The data does not always get imported to exact same place in the sheet, I'll clarify. The first column is supposed to contain a name, while the next 10 columns is supposed to contain data after running a web update. That's the ideal situation every time, and i'm updating once a day. Now the problem is that somedays the data is imported in a different way. For instance the name which is supposed to end up in the A column gets split up so it now takes up the two first columns instead of just the first (A) and this relays to all the other data which now ends up in the wrong column. I don't know if this problem derives from the source, changing it's tables or something else. Sometimes this issue won't arise for weeks then one day it's there again and ruins my day... Any help would be very appreciated. Regards Mitch |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing Microsoft query data into excel changes linked rows | Links and Linking in Excel | |||
Importing data to Excel using MS Query | Excel Discussion (Misc queries) | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
importing data from the query wizard | Excel Discussion (Misc queries) |