How do I retrieve changes to an unsaved excel document

I closed a excel document without saving changes.  Is there a way to retrieve 
my old worksheet which would have the changes I made.  I'm using excel 2000 
is part of my Microsoft Office 2000 program.

Jim8980 (510)
3/24/2006 1:18:02 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 48

No it's not possible



Peo Sjoblom

Northwest Excel Solutions

(remove ^^ from email address)

Portland, Oregon

"Jim" <> wrote in message
>I closed a excel document without saving changes.  Is there a way to 
> my old worksheet which would have the changes I made.  I'm using excel 
> 2000
> which
> is part of my Microsoft Office 2000 program.

3/24/2006 1:56:41 AM

Similar Artilces:

Excel 2000 sorting doesn't remember sort columns
I have an excel 2000 file that has several different worksheets. A few I need to sort occasionally. One of them has no problem, I can just go to data->sort and it remembers what I sorted by last time. A couple of others I have to re-choose the columns each time; it doesn't even remember whether the worksheet had a header row. Anyone know a fix for this? Thanks, Steve Can you assign a name to the range on each sheet that you want to sort? For example, if your headers are A1:H1 and data is A2:H1001, select the range A1:H1001 and assign it the name Sort_Range. If you have not done th...

explorer crashing when I change to thumbnail
Every time I change one particular folder to thumnail view on my ahrd drive, explorer crashes and I get an error. I have screenshots if that will help anyone. This all started after I did a Windows update and I'm a little tired of having to go onto another computer in the network to view files. I'm afraid to move anythign because I dont' want this to happen elsewhere. Please help. TIA Roberta Ur spiel chukkers broke two thumbnail problems wrote: > Every time I change one particular folder to thumnail view on my ahrd > drive, > explorer crashes and I ge...

Excel file name
Recently, Excel started saving my spreadsheets with the name I give the file followed by the .xls extension. Now, when I use the file name in the header or footer it appears on my printed report as "ABC Report.xls" rather than just "ABC Report". I don't want the .xls to appear, and can't figure out how to get rid of it. What happened and how do I change it back? I am using Excel 2002. Thanks for your help on this small, but very annoying problem. You probably changed an option in Windows Explorer. I'd leave it at the new setting (it's safer to see th...

Exporting EXCEL data in text (cvs) format
Is there no way to export EXCEL data to a text format e.g. cvs : "StringField1","StringField2",NumericField3,NumericField4,"StringField5" etc.? You can import from this format, why no export? Any work around? I'm the first person in the universe who wants an importable text version of his EXCEL data? Thanks! Woops! I didn't see the other options in the save as pulldown list. Sorry! Don't bother! "Simon Wigzell" <> wrote in message news:2FCNb.115599$X%5.16110@pd7tw2no... > Is there no way to export EXCEL da...

::: How to change formulas so I can copy them ? :::
Hi, I made formulas that are working good. But I can not copy them easily. Can anyone help me ? My problem is detailed into the following Excel file Thanks for your support. Jacques Try these formulas: C7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,6,FALSE) D7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,5,FALSE) E7: =HLOOKUP("ACTION TIME",DataBase!$C$6:$EA$11,3,FALSE) The dollar signs ($) "Lock" that part of the reference so it won't change when copied and pasted to another location. Another alternative woul...

Changing Values by Grouping and Dragging
Using OL 2003 Is there any way to change the subject line of a bunch of tasks or appointments at the same time? I used to be able to do this by grouping the items by subject and then dragging the highlited items to a different group but it won't work now with OL2003 Same thing for changing the Contacts associated with a Task or Appointment. Thanks ...

Change chart type in single data series, Excel 2007
I can't get it to change the chart type on a single data series in the new Excel 2007. The "change chart type" is grayed out. Thank you, What kind of chart is it? If it's a 3D chart, you can't change only one series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - _______ "momof3" <> wrote in message >I can't get it to change the chart type on a single data series ...

OL 2002 SP3: Documentation bug about client-only rules
There is incomplete information under the "My rule name contains Client Only" section of "Troubleshooting Outlook Rules" page (located at mk:@MSITStore:C:\Program%20Files\Microsoft%20Office\Office10\1033) It fails to mention that adding a rule to look for specific words in recipient's address also will also cause the rule to become client only. ...

Solver Add-In for Excel
Where can I download the Solver Add-In? "cram" <> wrote in message > Where can I download the Solver Add-In? With Excel 2003 it's on the cd: Tools - Add-Ins then select the Solver Add-In box. Hi you can't download it. It should be on your installation CDs -- Regards Frank Kabel Frankfurt, Germany cram wrote: > Where can I download the Solver Add-In? With all versions of Excel it is on the CD. You can purchase an enhanced version at J...

Changing from HQ to Single Store
I had two stores, one of which I have closed down. I was using HQ. All of my customers were set up as global customers. I have customers that purchased on credit and made payments in both locations. Now I want to eliminate HQ all together and just make my company a single store environment. I want to eliminate the HQ computer and second store computer. When I shut off the HQ computer, I can't check customer balances and make payments to customer accounts properly, and I can't send out statements. How can I go from an HQ to a single store environment and preserve all of the acco...

My Word Document is formated wrong on a PC
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I went for a job interview the other day and when I looked at the Resume they had printed out the formatting was off. The spacing between the sentences were ok but the type that should of been on the second was half way down the second page. I took my original PC word doc. and opened it up and the Mac and it's the same way only it backwards most the type that should of been on the second page most of it was on the first page. I even made the PC word doc a .rtf file but it's still wrong and I can't se...

Excel 2007
I cannot find the option to fill my charts with patterns (lines, dots, crosshairs, etc.) in MS 2007. Help, please. Thanks, Excel 2007 is a Windows version � you've posted to the group for Excel on the Mac. However, when you select a chart in 2007 there is a special set of contextual tabs that appear towards the right end of the Ribbon. Explore them as well as right-clicking chart components & selecting Format [Whatever] from the shortcut menu. But if you're looking for the same mundane bitmap Patterns provided in previous versions you won't find them. They may ...

Locked out of Exchange Administrator/directory for site, changed system account
Hello, I administer a single Exch 5.5 organization with two sites, one server per site. In Exchange Administrator, while connected to one of the servers, I must have inadvertantly removed a permission from the one-and-only system account configured for each site. Now when I start Exch Administrator in my default site I get the following error: A connection could not be made to the Microsoft Exchange Server computer 'name' You do not have the permissions required to complete the operation. Microsoft Exchange Directory ID no: DS_E_INSUFFICIENT_ACCESS_RIGHTS I can connect ...

Excel protecting formatting
Hi All How can I prevent cell formats from being removed or being overwritten when data is cut or pasted from another cell. I do not wish to rely on users having to use the "Paste Special" option. Many thanks Maybe you could just intercept the change. This worked in light testing. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim myFormulas As Variant On Error GoTo errHandler: myFormulas = Target.Formula With Application .EnableEvents = False .Undo End With Target.Formula = myFormulas errHandler: ...

Pocket Excel
Microsoft REALLY needs to support Excel drop down boxes for the pocket PC. Inputting is cumbersome with the Pocket PC and if there ever was an application that where drop downs would be useful it's on pocket excel. I realize some functionality must be sacrificed .... but not drop downs! How about a patch to upgrade? Hi as this is a peer-to-peer newsgroup you may try emailing MS directly: -- Regards Frank Kabel Frankfurt, Germany "brian" <> schrieb im Newsbeitrag news:4C8E8833-6EC6-45CC-82FC-6830F2B25FCF@microsoft....

Need a formula for Excel 2000..
Greetings & bless your little cottons for existing. I've never don anything more than autosum before and now my workplace has gifted m with a spreadsheet project that looks monumental to me. Can anyone tel me how..... If, in Sheet 1, the cell range C2-C41 contains "Cohen" anywhere AND th cell range R2-R41 contains "allowed" anywhere, I need to have th number of times that these two conditions are satisfied displayed a that number of times, in Sheet 2 at cell B2. So far I have =(IF((C2:C41="Cohen")*(R2:R41="Allowed"),) I can't find the command...

WXP registry to prevent changing of OL2003 tracking options?
Hi there, For those stand alone computers (i.e. won't/can't logon to AD), I would like to enforce outlook2003 email tracking. After I enforced the settings in outlook2003, users can accidentally/purposely revert the settings so that I can't track the email status. If there is any Winxp registry settings which can prevent users to change that email tracking settings? Many thanks! Not that I am aware of - however, whatever you do, they can undo. I personally hate tracking - many people use it to just check on you so that they can call you. I never return read-receipts t...

Why does the layout on a page keep changing?
I am having the weirdest difficulty with Publisher 2007. I use Publisher to create a multi-page bulletin. I had one template I was using for a 12 page bulletin. I used that for about a year. Then I changed to a new template that was 8 pages with a different font. The problem I am having is that when I open one of the old bulletins now (and have done so on multiple PCs) the formatting is all messed up. Text boxes that were full of text are now showing as blank, and the spacing is all messed up. Why would Publisher do this? ...

Using excel if function on a pricing spreadsheet
I am trying to simplify a pricing spreadsheet that I use at work. I a using the following criteria; the $ value of a product, the descriptio of a product that I have on a cost page. What I want to do is when type in the description of product X in a specific cell, I want the value of that product returned to another specific cell. Example: Lexan14SS (in a cell); 1.75 ($ value in another cell). On a pricing spreadsheet I type in Lexan14SS and I want that specific value returned to another cell. Of course though i will have mutipl product descriptions and prices to go along with those produc...

Convert text to number
Hi people, Thanks a lot to everybody. Unfortunatelly I cannot attach .xls file that I receive, because of excelforum's restrictions, it looks like usual excel file. I will try to use the advice of Debra. Thanks again, Irina. -- Irina ------------------------------------------------------------------------ Irina's Profile: View this thread: ...

Excel template similar to MS Money less investments?
Is there an Excel template or freeware that does the recording functions of M/S Money but doesn't involve investments and live updating ? Basically I'm looking for a check book program that makes some reports possible. ...

cant open Excel 2000 workbook with macros in XP
H I cant open any excel spreadsheats with macros that were made previously the come up saying this has a macro from 4 cant open in high security environmen Can anyone help????????????? Try changing the security settings on the xp excel. -- Don Guillett SalesAid Software "Murray Thompson" <> wrote in message > Hi > I cant open any excel spreadsheats with macros that were made previously the come up saying this has a macro from 4 cant open in high security environment > Can a...

Importing into Outlook 2003 from Excel (ss created in Office 2000)
Am having difficulty Importing data into Outlook/ Contacts 2003 from an older spreadsheet created in Office 2000. Everything in steps to import works except the actual transfer of data: e.g., the first field in the Excel spreadsheet ("City" field) imports correctly into Contacts (without any of the other imported fields). Then blank records are added for as many records there are in the next field: "Company" name. Have cleared all Flags during the Import/Export function in Outlook and am totally stumped as to how to fix. Thanks so much for the help. Rebel ...

I have uninstalled and reinstalled Microsoft's Office Pro with Frontpage. When I double click on an excel in a file without first opening the excel program, excel opens but it cannot find the file that I double clicked. Can anyone help me with this problem? Wayne Sometimes one of these works: Tools|Options|General|Ignore other applications (uncheck it) --- or --- Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows registry to excel's factory defaults. Wayne Ri...

How do I plot a v-mask in excel?
Anyone know how to take a Cusum chart and plot a v-mask on it? Hi, And for those not in the know, what is a v-mask? Cheers Andy -- Andy Pope, Microsoft MVP - Excel "JerryA" <> wrote in message > Anyone know how to take a Cusum chart and plot a v-mask on it? On Fri, 11 Jul 2008, in microsoft.public.excel.charting, Andy Pope <> said: >And for those not in the know, what is a v-mask? I googled, thinking "cusum" might...