Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Excel and MS HTML HELP Workshop

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Excel and MS HTML HELP Workshop

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Excel and MS HTML HELP Workshop

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Excel and MS HTML HELP Workshop

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Excel and MS HTML HELP Workshop

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add link to specific Excel worksheet in HTML Outlook message [email protected] Links and Linking in Excel 4 May 17th 23 11:47 AM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to convert HTML data into Excel? The Accidental Tourist Excel Discussion (Misc queries) 0 March 9th 06 05:21 PM
Using Excel to analyze HTML GreggRoberts Excel Discussion (Misc queries) 2 January 1st 05 04:41 PM
HTML to Excel Billing Goddess Excel Discussion (Misc queries) 5 December 10th 04 05:11 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"