Ask Your Question
0

Can't import external data from web page into Calc

asked 2019-09-18 22:27:52 +0200

sremick gravatar image

So I'm having trouble inserting data from a website. I'm trying to import mortgage interest rates from the table at this website:

http://www.vermontfederal.org/home/rates

When I add it however I get "No named ranges available in the selected document". Doing a Google search on that error was unproductive.

The data is just in a table on this website, so I'm not sure what the problem is...?

edit retag flag offensive close merge delete

Comments

Hello,

Actually there is no table with the provided link. Once there you need to click on another item to display the table wanted. This is not part of linking to external data.

Ratslinger gravatar imageRatslinger ( 2019-09-19 01:51:02 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-09-19 01:36:43 +0200

@sremick,

An alternative is to save the site to your machine (Open the site and use File / Save page as or Ctrl + S).

Open calc and use Link External Data on your machine copy. (Copy path where saved and paste in link)

image description

-----------------------------------------------------------------------------

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more

Comments

Unfortunately this defeats the goal of being able to keep live data in the spreadsheet to use in calculations

sremick gravatar imagesremick ( 2019-09-19 05:05:56 +0200 )edit
0

answered 2019-09-19 01:12:29 +0200

gregors15 gravatar image

Hi, Have you been able previously to get data from this Web site? I have used Sheet/Link to External Data to other sites for stock prices, historical oil prices and got them to work, but cant get it to work for the site you wanted. Could it be something to do with how the Web site has been setup?

edit flag offensive delete link more

Comments

No, this is the first time using that page and actually the first time I've tried pulling in web data in LibreOffice (although I used to do it from time to time in Excel).

sremick gravatar imagesremick ( 2019-09-19 05:05:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-18 22:27:52 +0200

Seen: 52 times

Last updated: Sep 19