Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I do not know if I am in the right community but here goes:
I'm using Windows 2000 Professional, MS Office 2003 and HTML HELP Workshop version 4.74.8702.0 I have a Word document with a hyperlink to my workplace network server that I save as HTML document. This hyperlink is to retrieve an Excel Spreadsheet. The HTML document is listed in HTML HELP Workshop under the Contents tab. I then compile the HTML HELP Workshop Project. When I double click the compiled HELP project it comes up find then I locate my HTML document with the hyperlink to the Excel Spreadsheet and click on it. The spreadsheet is found on the network server and is displayed in the current window but then a SAVE AS pop up displays asking the Excel spreadsheet to be saved. So, after a long story my question is WHY is it asking me to save the spreadsheet when nothing has changed? I want the user to be able to view this spreadsheet and not have to put up with cancelling the SAVE AS pop up to do so. Thanks in advance for any leads that might help to resolve this issue.... |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
WHY is it asking me to save the spreadsheet when nothing has changed?
If this is an Excel issue the answer is likely that the workbook has a volatile function(s) in it (like NOW()) which Excel always calcs and thus there is a change. A solution to this problem is to open the VBE and paste this code into the workbook's Thisworkbook module: Private Sub Workbook_BeforeClose(Cancel As Boolean) Saved = True End Sub -- Jim "Landon" wrote in message ... |I do not know if I am in the right community but here goes: | | I'm using Windows 2000 Professional, MS Office 2003 and HTML HELP Workshop | version 4.74.8702.0 | | I have a Word document with a hyperlink to my workplace network server that I | save as HTML document. This hyperlink is to retrieve an Excel Spreadsheet. | | The HTML document is listed in HTML HELP Workshop under the Contents tab. | I then compile the HTML HELP Workshop Project. When I double click the | compiled | HELP project it comes up find then I locate my HTML document with the | hyperlink to the Excel Spreadsheet and click on it. The spreadsheet is found | on the network server and is displayed in the current window but then a SAVE | AS pop up displays asking the Excel spreadsheet to be saved. | | So, after a long story my question is WHY is it asking me to save the | spreadsheet when nothing has changed? I want the user to be able to view this | spreadsheet and not have to put up with cancelling the SAVE AS pop up to do | so. | | Thanks in advance for any leads that might help to resolve this issue.... | | |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Jim,
I appreciate your response but, the spreadsheet has no functions. Just pure data. Landon "Jim Rech" wrote: WHY is it asking me to save the spreadsheet when nothing has changed? If this is an Excel issue the answer is likely that the workbook has a volatile function(s) in it (like NOW()) which Excel always calcs and thus there is a change. A solution to this problem is to open the VBE and paste this code into the workbook's Thisworkbook module: Private Sub Workbook_BeforeClose(Cancel As Boolean) Saved = True End Sub -- Jim "Landon" wrote in message ... |I do not know if I am in the right community but here goes: | | I'm using Windows 2000 Professional, MS Office 2003 and HTML HELP Workshop | version 4.74.8702.0 | | I have a Word document with a hyperlink to my workplace network server that I | save as HTML document. This hyperlink is to retrieve an Excel Spreadsheet. | | The HTML document is listed in HTML HELP Workshop under the Contents tab. | I then compile the HTML HELP Workshop Project. When I double click the | compiled | HELP project it comes up find then I locate my HTML document with the | hyperlink to the Excel Spreadsheet and click on it. The spreadsheet is found | on the network server and is displayed in the current window but then a SAVE | AS pop up displays asking the Excel spreadsheet to be saved. | | So, after a long story my question is WHY is it asking me to save the | spreadsheet when nothing has changed? I want the user to be able to view this | spreadsheet and not have to put up with cancelling the SAVE AS pop up to do | so. | | Thanks in advance for any leads that might help to resolve this issue.... | | |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
No harm in trying my suggestion anyway. If it doesn't help then it is not
an Excel issue, meaning it is not Excel that is asking you to do a Save. -- Jim "Landon" wrote in message ... | Jim, | | I appreciate your response but, the spreadsheet has no functions. Just pure | data. | | Landon | | "Jim Rech" wrote: | | WHY is it asking me to save the spreadsheet when nothing has changed? | | If this is an Excel issue the answer is likely that the workbook has a | volatile function(s) in it (like NOW()) which Excel always calcs and thus | there is a change. | | A solution to this problem is to open the VBE and paste this code into the | workbook's Thisworkbook module: | | Private Sub Workbook_BeforeClose(Cancel As Boolean) | Saved = True | End Sub | | -- | Jim | "Landon" wrote in message | ... | |I do not know if I am in the right community but here goes: | | | | I'm using Windows 2000 Professional, MS Office 2003 and HTML HELP Workshop | | version 4.74.8702.0 | | | | I have a Word document with a hyperlink to my workplace network server | that I | | save as HTML document. This hyperlink is to retrieve an Excel Spreadsheet. | | | | The HTML document is listed in HTML HELP Workshop under the Contents tab. | | I then compile the HTML HELP Workshop Project. When I double click the | | compiled | | HELP project it comes up find then I locate my HTML document with the | | hyperlink to the Excel Spreadsheet and click on it. The spreadsheet is | found | | on the network server and is displayed in the current window but then a | SAVE | | AS pop up displays asking the Excel spreadsheet to be saved. | | | | So, after a long story my question is WHY is it asking me to save the | | spreadsheet when nothing has changed? I want the user to be able to view | this | | spreadsheet and not have to put up with cancelling the SAVE AS pop up to | do | | so. | | | | Thanks in advance for any leads that might help to resolve this issue.... | | | | | | | |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Jim,
I did go ahead and implement your suggestion yesterday. It did not help. I'm thinking it's a MIME or is it MIMI issue but I don't know what to do if it is! Landon "Jim Rech" wrote: No harm in trying my suggestion anyway. If it doesn't help then it is not an Excel issue, meaning it is not Excel that is asking you to do a Save. -- Jim "Landon" wrote in message ... | Jim, | | I appreciate your response but, the spreadsheet has no functions. Just pure | data. | | Landon | | "Jim Rech" wrote: | | WHY is it asking me to save the spreadsheet when nothing has changed? | | If this is an Excel issue the answer is likely that the workbook has a | volatile function(s) in it (like NOW()) which Excel always calcs and thus | there is a change. | | A solution to this problem is to open the VBE and paste this code into the | workbook's Thisworkbook module: | | Private Sub Workbook_BeforeClose(Cancel As Boolean) | Saved = True | End Sub | | -- | Jim | "Landon" wrote in message | ... | |I do not know if I am in the right community but here goes: | | | | I'm using Windows 2000 Professional, MS Office 2003 and HTML HELP Workshop | | version 4.74.8702.0 | | | | I have a Word document with a hyperlink to my workplace network server | that I | | save as HTML document. This hyperlink is to retrieve an Excel Spreadsheet. | | | | The HTML document is listed in HTML HELP Workshop under the Contents tab. | | I then compile the HTML HELP Workshop Project. When I double click the | | compiled | | HELP project it comes up find then I locate my HTML document with the | | hyperlink to the Excel Spreadsheet and click on it. The spreadsheet is | found | | on the network server and is displayed in the current window but then a | SAVE | | AS pop up displays asking the Excel spreadsheet to be saved. | | | | So, after a long story my question is WHY is it asking me to save the | | spreadsheet when nothing has changed? I want the user to be able to view | this | | spreadsheet and not have to put up with cancelling the SAVE AS pop up to | do | | so. | | | | Thanks in advance for any leads that might help to resolve this issue.... | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add link to specific Excel worksheet in HTML Outlook message | Links and Linking in Excel | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to convert HTML data into Excel? | Excel Discussion (Misc queries) | |||
Using Excel to analyze HTML | Excel Discussion (Misc queries) | |||
HTML to Excel | Excel Discussion (Misc queries) |