Insert online linked spreadsheet into other spreadsheet

**gab037** · 08-03-2012, 03:14 AM

Hello,

My question is as follows:

There is a linked spreadsheet on the internet, i.e. the data it is not directly on the webpage but instead you click on the link and then it asks you if you want to save or open the spreadsheet. I would like to insert a specific range of that online linked spreadsheet into an offline spreadsheet, so that the data is taken from the internet, and refreshed every so often. Is that possible? If so, any guidance would be much appreciated. It seems that if the spreadsheet wasn't linked (i.e. the table was on the page directly) I would just go into the new web query menu, then click on the yelllow arrow etc. but here that's not possible.

Thanks in advance for your help.
Gabriel

**bonny24tycoon** · 08-03-2012, 06:49 AM

Why dont you move and insert the sheet to the new workbook like in this screenshot. Doc1.docx

**gab037** · 08-03-2012, 09:52 AM

Hi,

It seems to be working now

Thanks for your answer!
Gabriel

**bonny24tycoon** · 08-03-2012, 11:25 AM

Thats great

Can you mark this thread as solved?? To mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

**Cutter** · 08-03-2012, 04:05 PM

@ gab037

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.