Load all data not only filtered data on refresh

Load all data not only filtered data on refresh

Hi, 

Currently I do auto refreshes from Excel files i have on my OneDrive, sometimes those Excel files can have a filter on one of its columns and when ZOHO refreshes only the filtered data is loaded into the table, is there a way that all the data from the Excel file is refreshed every time nonetheless it has a column filtered or not? 
Thanks in advance!