Using web folders for excel references

Excel allows for cells to retrieve information from other cells, worksheets & entirely different spreadsheets using Cell References. Web Folders can leverage this feature so that you can reference cells in spreadsheets located in your workspaces. Take a look at the following spreadsheet "grades":



You can take the numbers in row 5 of this spreadsheet and have the average show up in spreadsheet "averages":



Before you begin Excel references via WebFolders you must first setup Web Folders on your system. Once you have this setup you can refer to other spreadsheets by inserting the following code in the formula bar:

=Excel-function('[filename]Sheetname'!Cell Reference)

Was this article helpful?       
0 out of 1 found this helpful

Have more questions? Submit a request