I've struggled to explain this issue before (please see link to previous post below) and did not receive a response unfortunately. I got around this issue last year but I'm going to struggle this time around due to a significant increase in the data I intend on presenting.
http://www.mrexcel.com/forum/showthread.php?t=376635
I am distributing USB devices which contain a lot of information on budgets and actual results (previously only showed budget information which was why it was easier to skirt around the issue) and these reports are all hidden and the user can access them by following links on a series of web page indexes (I created the index in Excel and simply published as a web page).
My issue is that the user is initially presented with an index which they can then choose to look at actual or budget information, and from there which year of actual or budget data. I want people to be able to navigate back to this page and any pages in between from wherever they are.
So for example if they choose to look at actual information the link would take them from the root of the USB device (where the main index is located) and go into the 'Actual' folder where they would then be presented with the option of which year's information they wanted to view, using a hyperlink in the pre-published Excel worksheet for this index as follows:
=HYPERLINK("./Actual_Reports/Actual_Year_Options.htm","Actual Reports")
If they then decided to look at budget information instead, while in the index showing the years of actual information available I need the user to be able to navigate back to the previous index (not by simply using the back button in explorer).
I have done this in Excel by manipulating the CELL("FILENAME") function but as these USB devices will be opened on many computers in various locations I need the flexibility of always navigating to and from the root of wherever is opened, which is where the "./" comes in within the hyperlink, and works great for navigating into folders, but I can't get back out of them.
Apologies for this rather long rant, any help would be greatly appreciated as I am desperate to find a solution for this persistant problem.
http://www.mrexcel.com/forum/showthread.php?t=376635
I am distributing USB devices which contain a lot of information on budgets and actual results (previously only showed budget information which was why it was easier to skirt around the issue) and these reports are all hidden and the user can access them by following links on a series of web page indexes (I created the index in Excel and simply published as a web page).
My issue is that the user is initially presented with an index which they can then choose to look at actual or budget information, and from there which year of actual or budget data. I want people to be able to navigate back to this page and any pages in between from wherever they are.
So for example if they choose to look at actual information the link would take them from the root of the USB device (where the main index is located) and go into the 'Actual' folder where they would then be presented with the option of which year's information they wanted to view, using a hyperlink in the pre-published Excel worksheet for this index as follows:
=HYPERLINK("./Actual_Reports/Actual_Year_Options.htm","Actual Reports")
If they then decided to look at budget information instead, while in the index showing the years of actual information available I need the user to be able to navigate back to the previous index (not by simply using the back button in explorer).
I have done this in Excel by manipulating the CELL("FILENAME") function but as these USB devices will be opened on many computers in various locations I need the flexibility of always navigating to and from the root of wherever is opened, which is where the "./" comes in within the hyperlink, and works great for navigating into folders, but I can't get back out of them.
Apologies for this rather long rant, any help would be greatly appreciated as I am desperate to find a solution for this persistant problem.
