how to donwload the spreadsheet posted in the postings

[venkat1926]

I have senn FAQ . probably this is not available there.

if a spreadsheet is posted in a posting through html maker how am to to download this spreadsheet into my excel file for futher working. Now what I do is using excel
data menu-import external data through a web query and download the whole page of the posting and remove the rows and columns outside the spreadsheet.

In the import window I am not able to tick the spreadsheet only. That is why I have to download the whole page.

is there any easier way?

venkat

 

[erik.van.geit]

Hi, venkat1926,

you can rightclick the table and choose
"Export to Microsoft Excel"
you will still have some work to do + copy-paste formulas

using "Table-It" you can select the table+formulas, hit a button and everything is pasted to the original location without further operations

kind regards,
Erik