LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Updating external data

It sounds like the data you are retrieving has had it's format changed. This
happens sometimes, (actually to me, a lot, from my MIS dept <g). Probably
your linking or Query or macro will have to be re-written.

hth
Vaya con Dios,
Chuck, CABGx3



"TMc" wrote:

Hi, I apologize if this has already been asked but I did not see it. I have
a worksheet with about 1000 rows of data from the web linked to it. Whenever
I go to update the data, all of the information comes back all distorted, in
rows where it should not be. Is there any way to ensure the data stays where
it should after the update, as the cells are linked to another worksheet so
it is causing some issues there. Thanks in advance for any help.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External data not updating [email protected] Excel Discussion (Misc queries) 0 March 16th 06 01:14 AM
Auto updating pivot tables using external XML data serdar New Users to Excel 0 March 12th 06 06:29 AM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
How can I have the Import External Data dialog pop up on open? Benny Setting up and Configuration of Excel 1 November 19th 05 10:13 AM
External Data Source updating on open, how to turn back on prompt. kristy Excel Worksheet Functions 1 March 15th 05 05:33 AM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"