BUG: read_excel not loading entire datasheet of .xlsx file
- [x] I have checked that this issue has not already been reported.

- [x] I have confirmed this bug exists on the latest version of pandas.

- [ ] (optional) I have confirmed this bug exists on the master branch of pandas.

---

**Note**: Please read [this guide](https://matthewrocklin.com/blog/work/2018/02/28/minimal-bug-reports) detailing how to provide the necessary information for us to reproduce your bug.


The code I'm using is the following:
#### Code Sample, a copy-pastable example

```python
DeathURL = 'https://www.dshs.texas.gov/coronavirus/TexasCOVID19DailyCountyFatalityCountData.xlsx'
TxDeath = pd.read_excel(DeathURL, engine='openpyxl', sheet_name='Fatalities by County')
TxDeath.shape
```
The output is:
```
/Users/rgrasmus/anaconda3/lib/python3.7/site-packages/openpyxl/styles/stylesheet.py:221: UserWarning: Workbook contains no default style, apply openpyxl's default
  warn("Workbook contains no default style, apply openpyxl's default")

(0,1)
```

#### Problem description
I am trying to read an online excel .xlsx file that is updated daily via Pandas (version 1.0.5) with openpyxl engine (version 3.0.7). Before updating Pandas and xlrd recently, the file loaded appropriately. Currently, it is raising a warning that openpyxl is applying a default stylesheet and the Dataframe that loads is only the first cell of the worksheet instead of the whole worksheet.

#### Expected Output
I am expecting Pandas to load a ~388x259 worksheet.
I have tested openpyxl directly and it seems to load the entire worksheet:
```python
import openpyxl
import requests
DeathURL = 'https://www.dshs.texas.gov/coronavirus/TexasCOVID19DailyCountyFatalityCountData.xlsx'
resp=requests.get(DeathURL)
output = open('test.xlsx', 'wb')
output.write(resp.content)
output.close()
TxD = openpyxl.load_workbook('test.xlsx')
TxDSheet = TxD.active
print(TxDSheet.max_column)
print(TxDSheet.max_row)
```
Output from the above:
```
388
259
```
#### Output of ``pd.show_versions()``

<details>

INSTALLED VERSIONS
------------------
commit           : None
python           : 3.7.7.final.0
python-bits      : 64
OS               : Darwin
OS-release       : 20.3.0
machine          : x86_64
processor        : i386
byteorder        : little
LC_ALL           : None
LANG             : en_US.UTF-8
LOCALE           : en_US.UTF-8

pandas           : 1.0.5
numpy            : 1.18.5
pytz             : 2021.1
dateutil         : 2.8.1
pip              : 21.0.1
setuptools       : 52.0.0.post20210125
Cython           : 0.29.22
pytest           : 6.2.2
hypothesis       : None
sphinx           : 3.5.3
blosc            : None
feather          : None
xlsxwriter       : 1.3.7
lxml.etree       : 4.6.3
html5lib         : 1.1
pymysql          : None
psycopg2         : None
jinja2           : 2.11.3
IPython          : 7.21.0
pandas_datareader: None
bs4              : 4.9.3
bottleneck       : 1.3.2
fastparquet      : None
gcsfs            : None
lxml.etree       : 4.6.3
matplotlib       : 3.3.4
numexpr          : 2.7.3
odfpy            : None
openpyxl         : 3.0.7
pandas_gbq       : None
pyarrow          : None
pytables         : None
pytest           : 6.2.2
pyxlsb           : None
s3fs             : None
scipy            : 1.6.2
sqlalchemy       : 1.3.23
tables           : 3.6.1
tabulate         : None
xarray           : None
xlrd             : 2.0.1
xlwt             : 1.3.0
xlsxwriter       : 1.3.7
numba            : 0.53.1
</details>
