Editing Refresh-able Data Tables from Web

[ms86]

Hi friends,

I have multiple data tables that are linked to a site. My issue is that there are breaks in the data every 15 cells with a row that shows the column categories. I locked my top row so I don't need the recurring column categories at all, but when I delete them and refresh the data they reappear.

Does anyone know how to delete these rows? Could I possibly run a macro that deletes the rows upon hitting refresh? Or is there a simpler way?

I appreciate the help.

Mike

[ms86]

Got it. Had to convert the data into a table, which I should've done in the first place.

Edit: I guess I didn't figure it out... Once I put the data into a table it deleted the connection to the site I imported from. Is there any way to re-link it to the web? I'm lost...