2 Replies Latest reply on Jul 27, 2016 8:38 AM by kywest

    Excel Formula Referencing

    kywest

      I have multiple excel documents loaded and up to date within private space on our company's jive webpage. I want to make some of them reference to each other using excel formulas. For example I have an asset inventory and information workbook and a supply inventory workbook. I would like the inventory workbook to validate the machines existence based on the EID provided and comparing it to a list of devices. Currently I just copy and paste the asset list into the Supply inventory, however I would like to make this more dynamic and updated more "Real Time" every time the file is opened.

       

      Is it possible to for two excel files hosted on jive to access each other through macro / formulas?