Google Sheet Import : Why Is Append Rows To Current Sheet Disabled?
@abrakadabra
•
Oct 25, 2024
Oct 25, 2024
1.8K
Anyone here uses Google Sheets for maintaining their excel data online?
I have multiple spreadsheets and want to combine their data into a single spreadsheet.
In the main Google Sheet, I clicked on File > Import.
It showed me all the spreadsheets available in my Google Drive.
I selected the one I wanted to merge with the main sheet.
It gave me following options -
As you can see from the image above, the actions for 'Create new Spreadsheet, Insert new Sheet and Replace spreadsheet' are enabled.
But the ones I need -
"Append rows to current sheet" or "Replace data starting at selected cell" is greyed out or disabled.
Anyone knows why that's the case? Am I doing something wrong or the feature isn't made available yet?
Any help would be great. 😀
I have multiple spreadsheets and want to combine their data into a single spreadsheet.
In the main Google Sheet, I clicked on File > Import.
It showed me all the spreadsheets available in my Google Drive.
I selected the one I wanted to merge with the main sheet.
It gave me following options -
As you can see from the image above, the actions for 'Create new Spreadsheet, Insert new Sheet and Replace spreadsheet' are enabled.
But the ones I need -
"Append rows to current sheet" or "Replace data starting at selected cell" is greyed out or disabled.
Anyone knows why that's the case? Am I doing something wrong or the feature isn't made available yet?
Any help would be great. 😀
