MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Accessing, Updating, & Saving Excel files on an Intranet


Posted by Matt on December 28, 2001 12:51 PM

I am wondering if it is possible to set up an Excel file on a companies intranet that can be accessed through the intranet, updated, and then saved/submitted back to the intranet files. This updated file would then update another read only file that shows totals. So basically, I am wondering if it is possible to have interactive Excel files on the web that update a separate web Excel file.

If anyone can tell me if this is possible and how it is accomplished, I would be very grateful.

Thanks,
Matt


Posted by Michael on December 28, 2001 1:01 PM

Yes, It is possible. Since all of the files that are saved on a company's intranet are stored on a server(Or network drive depending on how the network is set up), all you have to do is be very specific on the cell call outs. For example, if I needed to show a cell value from a different workbook saved on a network drive it would look something like this:
='networkdrive letter:\location\location\[filename]sheetname'!cellname

(=x:\michael\mike\[myworkbook]sheet1'!A1)

as long as you know the location of the files you want to pull the values from, you should not have any problems.

I am wondering if it is possible to set up an Excel file on a companies intranet that can be accessed through the intranet, updated, and then saved/submitted back to the intranet files. This updated file would then update another read only file that shows totals. So basically, I am wondering if it is possible to have interactive Excel files on the web that update a separate web Excel file.

Posted by Matt on December 28, 2001 2:22 PM

Thanks Michael. I guess my next question then is can I set up the Excel file so it is in Web format and all the user has to do is access it, update it and submit the changes while in the browser; or do they have to open the file in Excel and have access to the intranet files in order to save the updates?