Excel and MS HTML HELP Workshop

[Guest]

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....

 

[Jim Rech]

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
|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....
|
|

 

[Guest]

Jim,

I appreciate your response but, the spreadsheet has no functions. Just pure
data.

Landon

 

[Jim Rech]

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
| 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
| > | > |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....
| > |
| > |
| >
| >
| >

 

[Guest]

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