After that, you’ll see a message in Google Sheets that an update is available. Every time you add or change data in Excel and want it to show up in your Google Spreadsheet, click “Publish” on the Data Everywhere ribbon in Excel.Now, this feed will be synced across both spreadsheets. Click the “Insert Feed” button, and choose the feed you created in Excel.Go to your new or existing Google spreadsheet, and click the “Sign in to your Data Everywhere account” link (if you haven’t already) and Authorize Google Sheets.ĭon’t yet have our Google Sheets add-on? Learn how to install it by following our Google Sheets add-on installation instructions.Click “Create” at bottom of the dialog, and now you have a feed! If it’ll just be you using it to share between Excel and Google Sheets, no need to add anything. If you need other users of Data Everywhere to be able to access this data, you can put their email addresses in the Viewers or Editors box. Click “Create” in the Data Everywhere ribbon and give your feed a name and optional description.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |