I have created a local excel sheet in Microsoft excel in which i have used some formulas. I have hidden all the formulas used in it. But when i open the sheet via Google sheets one is able to see all the formulas clearly.
Is there any way we can hide the formulas from anywhere the sheet is opened.
As Player0 commented here, using importrange produced an error:
You don't have permissions to access that sheet. Learn more
01 Convert the xlxs file into Google sheet file, by going to File > Save as Google sheets.
02 Get the ID of the converted sheet and use it in the importrange formula in the shared spreadsheet in A1 like this.
=IMPORTRANGE("Converted_spreadsheet_ID", "Converted_spreadsheet_SheetName!=1:1000")
