Solved

Hyperlinking between tabs in a spreadsheet get message: The document has been modified. Do you want to save changes? How to prevent this?

Posted on 2004-04-26
2
292 Views
Last Modified: 2007-12-19
I have a spreadsheet with several tabs in use and hyperlinks that take you from the main tab to other tabs.  It works perfect when running in my PC.  When I upload the spreadsheet to a web server and invoke it from an html page, it opens as planned but clicking on a hyperlink to move to another tab in the same spreadsheet produces the following message:
The document has been modified.  Do you want to save changes?
Yes:           Save your changes
No:            Discards your changes
Cancel:      Keeps this document open.
followed by buttons for Yes, No, and Cancel

How do I prevent this message from coming up?  I've thought about converting the entire workbook to an html document but not sure it will continue to work and not sure how to go about this.  Since the workbook undergoes frequent changes, I'd rather keep it in Excel and FTP the changed version to the website.

Please advise.

Neil
0
Comment
Question by:nlesser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10924733
I think this is because the spreadsheet is opened within Internet Explorer, if you save the file to your harddisk and open it then I don't think you'll have the same problem.
0
 
LVL 23

Accepted Solution

by:
rama_krishna580 earned 500 total points
ID: 10924752
see here..

http://www.quark.com/service/desktop/support/techinfo/technotes.jsp?idx=34
http://www.webreference.com/js/column56/refresh.html


and check the Content-Type settings in the webserver side, the file types must me set in the configuration file of your webserver, please check then it will be ok...

R.K
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Easy responsive table out of existing table 28 62
Button to go back 3 39
I am having a  Git   issue 6 61
WordPress: Debugging from my Windows 10 Desktop 6 61
Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This video teaches users how to migrate an existing Wordpress website to a new domain.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question