Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Excel 2007 Web Query question/help

  • Please log in to reply
No replies to this topic

#1 Radukes07


  • Members
  • 1 posts
  • Local time:06:27 PM

Posted 20 December 2008 - 02:39 AM

Hi everyone.

I have set up a web query to refresh data every minute, however the data refreshes in the same cell so I am unable to track the data in say a line graph. Also, is it possible to get time stamps in the Cells next to it every time the data refreshes? I will provide some screen shots.

Posted Image

Ok, look at cell B1, I set it up so that data refreshes every minute, but every time it refreshes it only refreshes in cell B1, how can I make it so that every time I refresh the new data will be put into B2, and then B3, and then B4 and so on and forth. Also, is it possible to put time stamps in the A cells every time this data is refreshed? If so, how?

Thank you for the help!

Edited by Radukes07, 20 December 2008 - 12:41 PM.

BC AdBot (Login to Remove)


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users