I need help creating a link to an excel file that will open excel from a link on a Internet Page.
i created a link to an excel file (XLSX) that is on our Internet. This was my first time so I'm not sure if I created it correctly. The target path I used was C:\inetpub\internet\... and same for the shortcut - when I try the link I get a 'The Page cannot be found" I also tried creating the link using "\\internet\internet\..." but that didn't work either.
I verified the virtual directory exists in IIS as there are PDF files that open with no problem.
The link also works as I am able to open it from a mapped drive to the internet server.
If there is another way to open an excel file opening Excel from an Internet page or create a download button, I'm open to any options. Any help will be greatly appreciated.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…