Do you want to save changes?

Everytime a shared workbook is opened and then closed without changes being 
made to it, users are prompted by the following:

This document has been modified.  Do you want to save changes?

Yes:       Saves your changes.
No:         Discards your changes.
Cancel    Keeps this document open.

Using excel 2002.  Again, no changes are made and the prompt still comes up.

Thanks in advance for any help.
NWH
0
NWH (1)
12/7/2004 5:17:06 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
796 Views

Similar Articles

[PageSpeed] 41

Hi
not sure but could be a 'feature' of shared workbooks. another reason
could be the use of volatile functions:
http://www.decisionmodels.com/calcsecretsi.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"NWH" <NWH@discussions.microsoft.com> schrieb im Newsbeitrag
news:10E3D3AC-C51D-47D6-AA1F-BB67172DA3F2@microsoft.com...
> Everytime a shared workbook is opened and then closed without changes
being
> made to it, users are prompted by the following:
>
> This document has been modified.  Do you want to save changes?
>
> Yes:       Saves your changes.
> No:         Discards your changes.
> Cancel    Keeps this document open.
>
> Using excel 2002.  Again, no changes are made and the prompt still
comes up.
>
> Thanks in advance for any help.
> NWH

0
frank.kabel (11126)
12/7/2004 5:32:34 PM
Reply:

Similar Artilces:

changing the xsi:type
I have an arraylist with up to 4 different classes that can be contained. e.g.... <carpark> <car /> <truck /> <motorcycle /> <rv /> </carpark> It's largely working. The output is:- <carpark> <anytype xsi:type="xmlcar" /> <anytype xsi:type="xmltruck" /> <anytype xsi:type="xmlmotorcycle" /> <anytype xsi:type="xmlrv" /> </carpark> I've tried changing the element name, the arrayitem name, but I can't get it to rename from "xmlcar" to ...

Outlook Saving To Wrong Folder
Have options set to mail a message immediately and save a copy in "Sent Items" folder. It did that until about 2 weeks ago. Everything is still set in Tools -> Options as it was before. But now instead of sending the email to whomever I want it to go and saving the copy in the Sent Items folder, Outlook is sending the email to whatever folder I'm in when I click the "Reply" button. Haven't changed or added anything to system for about a month. What could have gone wrong. Tryn2lrn <answers@newsgroup.net> wrote: > Have options set to mail a messag...

Want to know if there is a canned project summary format that I can use/customize #2
Hi Debra, Thanks for the tip. I found some very interesting templates there However, I didn't find any that suits my needs. I will continue t search for that -- ssaiba ----------------------------------------------------------------------- ssaibal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1493 View this thread: http://www.excelforum.com/showthread.php?threadid=26567 ...

Query on multiple keys
I have a table that looks like this: ClientID RevisionNum --------------------------------- 10000 1 10000 2 10000 3 10000 4 20000 1 20000 2 30000 1 30000 2 30000 3 30000 4 40000 1 40000 2 40000 3 I would like to great a query that will return the following records: ClientID RevisionNum --------------------------------- 10000 4 20000 2 30000 4 40000 3 That is, I only want the record with the top value of RevisionNum. Any suggestions? On 10 May 2007 19:53:31 -0700, timorrill <timothy.morrill@gmail.com> wrote: &...

How can we get rid of the "Save" pop up box at the end of application?
Whenever the user closes the excel sheet, it pops up an "save?" pop up. Is there a way to get rid of this? --- Message posted from http://www.ExcelForum.com/ It should only ask that question if it thinks you have altered data on the sheet. The only way around this is to write a macro and place a button on the sheet that would close the sheet with one click without asking to save it first. You may be able to use an auto_Run macro to tell the sheet that you have already saved it and don' ask again. If you know how to do macros, the magic code is. sub CloseSheet() acti...

Mutual Fund Last Update and Day's Change not updating
THIS PRODUCT IS MICROSOFT!!! IT IS BILL GATES!!! How long will the developers allow this problem to go on??? I've used MSN Money's Portfolio for years and just started getting the problem in the past six months. A post from MS says "we are working with our data providers to supply the correct date". Fire the data provider and go back to the one you used for years. I think this is a MS programming error that should be fixed by an entry level programmer in two hours. I'll take that bet. "evy38" <evy38@discussions.microsoft.com> wrote in messa...

unlimited change tracking #2
I'd like to use change tracking similar to what Word has. I found such a feature in Tools | share workbook, but it limits you to a specified number of days. I want all changes tracked permanently--essentially version control...is that possible? _____ DC G ...

Change Preset Columns
My columns have 1,2,3, etc., how do I change them back to ABC,etc?? Its under Tools, Options, General Tab, uncheck R1C1 reference box. "Bernie" wrote: > My columns have 1,2,3, etc., how do I change them back to ABC,etc?? ...

trial version Outlook 2007 -Power Point Edit & Save
Just downloaded the trial. In Power Point, why can't I edit and save the doc? I can only view and print. Help! AndreaG wrote: > Just downloaded the trial. And what was the URL from where you downloaded? According to your Subject header, you downloaded the trial version of just Outlook 2007. I didn't realize that Microsoft had a separate trial of Outlook. They do have a trial version of /Office/ 2007. > In Power Point, why can't I edit and save the doc? > I can only view and print. Did you enter the 25-character *trial* product key after download...

COUNTIF: drag to change criteria, NOT range
Hello, I'm hoping that there's someone out there that can help with this problem. I'm trying to count values in one column so that I have an amount of each for a distribution. For example: 8 8 8 11 11 11 12 12 12 I'm using COUNTIF because it's the only one that seems to work, but whenever I drag to fill the series Excel doesn't fill in a linear fashion. Instead it repeats the formulas I've already entered. Here's an example of what I enter into the cells: =COUNTIF($A$2:$A$36,8) =COUNTIF($A$2:$A$36,9) =COUNTIF($A$2:$A$36,10) ....and so on. When I highlight...

GP 10 table changes
Is there a document available somewhere that lists the table changes made in release 10? Yes, this is widely documented in the Dynamics GP Software Development Kit, which can be found on CD2 of your installation software. Also, you can download updated versions from CustomerSource or PartnerSource. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, LLC http://www.maximumglobalbusiness.com "Elaine" wrote: > Is there a document available somewhere that lists the table changes made in > release 10? Hi Mariano, thanks for the quick response! I...

How do I change a default Message Delivery option?
I have a user who has managed to change his default email option to have "Expires after" turned on by default. I would like it turned off. I've tried turning it off and saving it as a template, but I would like it off in the default case... ...

Saving a password for an Exchange mailbox
Hello everybody, Outlook keeps asking me for my password when I log in to my Exchange server - I would like to save the password, though, and have Outlook log me in automatically. I presume this is possible because it works fine with my pop accounts. Any help is greatly appreciated. Cheers, Oliver What is the authentication type set under your Exchange server properties? Have you tried talking to your Exchange Admin about the password problem? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) viru...

How do I change the size of the automatic window outlook
Can I change the size of the initial window that outlook opens up into? I do not like it when it takes up the whole screen. "bhanley" <bhanley@discussions.microsoft.com> wrote in message news:E723FC0E-546B-4400-A689-0B1289EB0DEB@microsoft.com... > Can I change the size of the initial window that outlook opens up into? I > do > not like it when it takes up the whole screen. Make sure the shortcut you're using to start Outlook isn't specifying that Outlook should open maximized. If it's not, then size it the size you want by dragging the...

changing IP of the exchange server
Hi, I have windows 2003 with exchange 2003 server, running perfectly fine. Recently I have been assigned with a new IP address from my ISP and so I have to use the new IP address instead of the old one(It is a public IP address.) My query is can I change the old IP address to the new one without affecting the functionality of the server. Is this a working scenario.I don't want to try and disturb the current setup Please advice. Regards Vic On Sun, 11 Dec 2005 16:01:51 +0400, "Vikrant" <vikrant_nath@hotmail(removethispart).com> wrote: > >Hi, > >I ha...

Stan wants YOU to be in his future Global Empire
A quote from a post by Stan a little while ago: > But that''s how you become World Dominator or Emperor. > Listen Dan, if you're friendly enough I can make you Vice President in my > future Global Empire. So if you want to be in his Global Empire, send him an e-mail stating which job you would like. It seems that Vice President is still open. I am sure many high level cabinet positions are also open. Maybe even Minister of Evolving Brain Farts. Hurry, positions are going fast! LOL! I would like to create a new bureaucracy. I would like to...

Cannot publish the changes made to the Forms in MSCRM
Hi, I just made some changes in the Lead and Oppurtunity forms in MSCRM but when i publish the forms in the Deployment manager, Though it says that it has been published successfully it still doesn't reflect the changes when i open a new Lead or Oppurtunity form...could anybody please help...I have tried this on 2 other MSCRM servers...it works well there..... If anybody could help me with this i'll be really thankful. For performance reasons, the CRM servers cache the XSL files that represent the forms you just published. 9 times out of 10 a simple IISRESET on the Web Server ...

Changing hourly increment in Plan A Meeting/Meeting Request window??
I have a user who, when she goes to Plan a Meeting/Meeting Request window, she sees 3 hour increments (on the timeline to the right of each selected attendee). INcrement go... 12 o'clock (space)3 o'clock(space) 6 o'clock, etc. I cannot recreate it. Changing the normal calendar view does not affect it. I have combed thru every menu and submenu with no luck. any ideas? ...

Sound in email when I want
My provider has a very good spam checker which labels mail. I can set up a filter to send such mail, which also does not come from anyone in my address books, to a folder for checking later. I don't want either the sound or notification when this happens, but I do want both of these when 'good' mail comes in. Is there a way? -- Jim S Tyneside UK http://www.jimscott.co.uk "Jim Scott" wrote in message news:Xns996DD27019080jim.jimXscott.co.uk@85.214.90.228... > My provider has a very good spam checker which labels mail. I can set > up a > filter to ...

How do I bring up a file that I saved as an Excel file?
I am taking classes and have to do work on Excel and was wondering why when I save them I can't retrieve them? I can see the file names but am not able to retrieve them I am inexperienced on Office. Hi open excel, choose file & open, locate your files, click on the one you want to open and press the Open button. however, if the files that you want to open are on a floppy disk then it is a VERY good idea to copy them onto your hard drive before opening them. This is best achieved using windows explorer. to do this: right mouse click on the start button choose explore ensure the flo...

IE Crashes when trying to change properties on Lead Form
When I try to change the properties on the Lead Form (specifically on Lead Source) IE closes with the dialoge box asking if I want to send information to Microsoft. Is there a setting that I need to change before I am able to customize fields on a form? Thanks, Hi, This seems to be a bit of a wierd problem. What version of IE are you using? Have you tried to do this from a different PC? To me it seems IE is having some troubles. You should be able to modify the forms without any wierd settings. You could also try to lower your security settings (making sure ActiveX and scripting is...

sent messages are not saved in the sent items folder
Hi! With no special reson, and with everything configured the way it should be my outlook 2002 just stopped saving the sent messages in my sent items folder any idea? Thanks in advance, Nir. There is a setting for that. You might want to check it just to be sure. Under Tools, Options, Preferences, Email Options, there is a box that says "Save copies of messages in Sent Items folder". Is that checked? >-----Original Message----- >Hi! >With no special reson, and with everything configured the way it should be >my outlook 2002 just stopped saving the sent messages...

ON RECORD CHANGE
I would really like some on record change events off of which I could run code how about on record change on previous record on next record on last record on first record just like the nav buttons at the bottom of a form. IUt's really irritating to have to make custom nav buttons just so I can run code off of them. -- BlueWolverine MSE - Mech. Eng. Go BLUE! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see ...

Auto save in excel 2000 keeps reverting to 10 minutes
I keep trying to change the time between auto-saves to 30 minutes, but every time I reopen excel 2000 it is back to 10 minutes. How do I get this change to be permanent? Thanks. Create a workbook with this code in a general module: Option Explicit Sub auto_open() On Error Resume Next Workbooks("autosave.xla").Excel4IntlMacroSheets("Loc Table") _ .Range("ud01n.Frequency1").Value = 10 If Err.Number <> 0 Then MsgBox "Timer not changed!" Err.Clear End If On Error GoTo 0 'ThisWorkbook.Close SaveChanges:=False ...

Change hour by one
I'm setting up a chart to show the changing sunrise and sunset throughout the year. The sunrise and sunset info has been converted to daylight saving time and I want to convert the hours back to GMT. This means changing a time such as 07:10:42 to 06:10:42. Obviously this can be done manually, but how to do it en mass? Rob Graham Times are stored in Excel as fractions of a 24-hour day, so that 1 hour is actually stored as 1/24. Basically, you want to subtract this from all your times. In an empty cell somewhere, enter =3D1/24. Select that cell again and click <copy>...