I have a large no of Excel lists in various Excel 2003 worksheets within a workbook. The lists refer to hyperlinks to individual files stored on an intranet Server
I have successfully saved some of these to a Web page with interactivity enabling users to have a filterable list of these many hyperlinks which the can then access
The value to me is that I have one place where I can know where my links are and can provide access to those links by the saved Web page. When a user clicks a link in the web page they do not access my list which is protected for my use. Additionally, if I change a link or add one in my worksheet Excel will automatically republish the web page
BUT on some of my worksheets I get an error when trying to create the web page with interactivity
I get the following error
The Microsoft Spreadsheet component could not load the XML data. Validation
Load Error: ForType List, the absence of a <cell Range list> tag implies
relative cell reference in the list values which is not allowed
I have tried long and hard to figure out the problem why this occurs for some of my worksheets but not others
I suspect it must be a simple error in how the failed worksheets are formulated but it beats me. Any ideas?
The value of creating lists in Excel and in effect exporting to a simple HTML sheet via save as web page helps enormously in distributing lists (mine is to enable hyperlinks for hordes of stuff for an Office Manual with Knowledge base)
Help great fully received plus any other tricks to protect source data access while enabling user access (many links are to secure PDF files but also to Word documents and PowerPoint auto displays (for traing)
I have successfully saved some of these to a Web page with interactivity enabling users to have a filterable list of these many hyperlinks which the can then access
The value to me is that I have one place where I can know where my links are and can provide access to those links by the saved Web page. When a user clicks a link in the web page they do not access my list which is protected for my use. Additionally, if I change a link or add one in my worksheet Excel will automatically republish the web page
BUT on some of my worksheets I get an error when trying to create the web page with interactivity
I get the following error
The Microsoft Spreadsheet component could not load the XML data. Validation
Load Error: ForType List, the absence of a <cell Range list> tag implies
relative cell reference in the list values which is not allowed
I have tried long and hard to figure out the problem why this occurs for some of my worksheets but not others
I suspect it must be a simple error in how the failed worksheets are formulated but it beats me. Any ideas?
The value of creating lists in Excel and in effect exporting to a simple HTML sheet via save as web page helps enormously in distributing lists (mine is to enable hyperlinks for hordes of stuff for an Office Manual with Knowledge base)
Help great fully received plus any other tricks to protect source data access while enabling user access (many links are to secure PDF files but also to Word documents and PowerPoint auto displays (for traing)