Your internet connection is lost. Wait and try again , atau Refresh Page.

Covid 19 India Active Cases State wise details



When you’re opening a Sheets document in Excel, not all spreadsheet functions will make the transfer. The key items to be aware of are macros and formulas.

Macros won’t transfer because Excel and Google Sheets each use different scripting languages to create and store them. VBA (Visual Basic for Applications) is the scripting language Excel uses; Google Sheets uses Google Apps Script. When you convert macros in Google Sheets documents to Excel, you will have to recreate those macros after you open the documents in Excel.

Both applications use formulas. While there is a lot of overlap between the formulas Google Sheets and Excel use, there are many that only work in one of the applications or in which the format is different. When you move a document from Sheets to Excel, most formulas will continue to work, but you should still verify all of them.

Before you transfer documents, make note of any macros and formulas, so you can recreate the macros and verify if the formulas are working after you open the document in Excel.

1 comments:

avatar

Nice post and informative