I have table in teams having around 6000 records (it has 128 columns).
I wanted to edit the data in excel, so selected the option "Edit Data in Excel", It created Excel file in my local drive.
Open it, all was fine but display an information as below :
Later I understood that 10,00,000 (that it can refresh the data of 1 million cells only at this time).
But confused what is my situation. So selected all columns and rows and result at the bottom on the excel sheet as below
Its shows count 641,615, this means total cell selected is this.
Please clarify my below doubt:
a) I am within the limit of refresh (based on the above images)
b) For my learning purpose, is there way to increase these limit mention in the info dailog?.
c) any video link to study and know more about this topic for future use and for confidence in datahandling
Please advise
