Share via

How do i 'Alter and remove' Live Web Data in Excel (Im a noob)

Anonymous
2020-04-30T17:39:09+00:00

Im at a lost end, im totally new to this 'live web data' and just learnt how to import some data to xcel using youtube, however im now stuck and cannot find any videos to help me. 

I want the data imported to still have its 'Live refresh updating' feature however i dont want any other cells/info except for 'cell 1' how do i do this?

I think i worked out how to remove the other 4 cells but i couldn't work out how to remove the title 'stormscale eu' part.

What im trying to do is simply insert the cell circled in BLUE into a table i have already created on another xcel sheet ONLY. I want that figure on its own and to retain its updating feature upon refresh so that i can recalculate my tables.

Hopefully this makes sense thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-30T18:52:41+00:00

    Hi,

    Per your description, we understand you want to delete the column header of the data imported from the website. First, we would like to let you know when you import the data from the external sources into the Excel file, the imported data will be converted as Table and the first row of the content will be the table header. In order to delete the column header in the table, you need to remove the table and delete the header. And removing the table which means converting the table to range will lose the connection.

    So, since you’re having only one column, you can uncheck the header row option:

    Click on the table in the Worksheet> Table Design> Uncheck Header Row.

    Appreciate your patience and understanding. Have a good day and stay safe 😊

    Best Regards,

    Chitrahaas

    0 comments