I am running a web query on a 540 record table on a website. I get the message

" The query returned more data than will fit on a worksheet."

and the data is truncated to 515 records. Is there a way I can get the web
query to show the whole details ?

Cheers in advance