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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
"In order to have an organized way for empathy mapping, we rely on a psychological model and trying to model it in a simple way, so we will split the board to three section for each persona and a scenario and try to see what those personas would Do,…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now