Working in a master workbook on F:\ server and linking to other workbooks in various folders on that same server. I noticed a few links show the array beginning with:
=Excel.Sheet.8|'\\pmtv-file\public\NTExcel\Operations\ and file/tab reference
while all others have the familiar link
='F:\NTExcel\Operations\ and file/tab reference
Can anyone tell me why using the exact same linking method would result in 2 different paths??
p.s. each time I open the master WB 9 linked workbooks with the "=Excel.sheet.8" path link i get the message This workbook contains links to other data resources" and if i choose update, they 9 linked workbooks "flash" open and ask to update etc. I have tried re-linking but get the same results.
It would appear the first example browsed to the link and so showed the full link and the second example had a mapped drive and so used the drive letter. I see both and what you see is normal.
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…
The viewer will learn how to create a slide that will launch other presentations in Microsoft PowerPoint.
In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: