Pivot Table from Web Source Data

[aja0004]

I brought in external data from a web source and have a connection maintained with the data, butI cannot create a Pivot Table or even a regular Table from the imported data without having to remove the connection. Is there a way to create a Pivot Table that will stay linked to this external web source?

Thank you!!