Cannot expand balance sheet on Yahoo finance while using "new web query" / "get data from web" tool

I am trying to use the "new web query" / "get data from web" feature in excel in order to get real-time/live financial data from Yahoo Finance. I need the detailed financials from the balance sheet, so I hit the "expand" button while using in my browser. However, when I try to do this in the "new web query" / "get data from web" feature in excel, I am not able to expand it. Any help is much appreciated!