Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-10-2020, 07:39 AM
DBenz DBenz is offline How can I close my currently open Excel without it saving ? Windows 7 64bit How can I close my currently open Excel without it saving ? Office 2010 32bit
Advanced Beginner
How can I close my currently open Excel without it saving ?
 
Join Date: Dec 2014
Posts: 66
DBenz is on a distinguished road
Default How can I close my currently open Excel without it saving ?

Hi



Office 2010,
I have just seen excel place columns B to N into A wiping out all the text for the transactions whose prices were in B onwards, which were headed Jan to Dec in B to M and the totals in N.


It would be stupid to close Excel as it would save that, as it is, unless it is saving as I work Excel (is it ?) in which case I am nuked, I need to close Excel without it saving everything I did and it did without me wanting what it did, open it (the good one) up again to see that page before this happened.


Furthermore what happened there ?

All I did was paste the text from row 20 into row 21 then I couldnt get rid of the 'crawling ants' so I hit esc, nothing, clicked another sheet, then went back and A had then received B C D etc all stuffed into A ! A is in fact now made up of columns, so at the very top is a wide grey cell A, next row says Subject, below that are columns with data from B onwards which still exists beyond the dark line at RHGS edge of A.
If I click in the first of these columns that selected cell also at the same time is also selected in B, and as I tab right, I am seeing double selections, so its mirroring the columns B C etc in A !



I clicked undo but no joy.


I will keep excel minimised to taskbar until someone can help.


I recall having this happen once before and had to research and rebuild an entire page again, took the entire day.


What I do want to set up after getting out of this pickle is to STOP Excel saving without me wishing it, during use and when closing, as in all other progs I DECIDE TO SAVE, I do Ctrl S every so often when I am happy with what I want to save, else a prog can save the actions of a gremlin !


Is there some place that incremental saves get made to during using Excel 2010, maybe I can look through those if there is no other way to get out of this pickle.


Also I seem to have a limited number of undos, 2 and that was that, can I extend the number in preferences or would there have been more but the gremlin has denied me undoing its actions ?


Thanks

DBenz
Reply With Quote
  #2  
Old 12-10-2020, 12:18 PM
Purfleet Purfleet is offline How can I close my currently open Excel without it saving ? Windows 10 How can I close my currently open Excel without it saving ? Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

have you tried to make a copy of the file via windows explorer?

press the windows key and e, the navigate to the location of your file then right click on it > copy, paste it int he same folder and it should called copy of....... or another folder

then open the copy and see how it looks.

I know excel keeps back up copies now dayts, but not sure what it will look like in 2010
Reply With Quote
Reply

Tags
disable, save

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I close my currently open Excel without it saving ? Open en close Chapters edwinm Word VBA 6 08-12-2017 01:25 PM
Open/close window in Outlook AndyDDUK Outlook 0 02-04-2013 07:07 AM
How can I close my currently open Excel without it saving ? Word 2003 slow to open/close HAWJOHN Word 1 04-05-2011 06:47 AM
Lines move between close and open jsmath22 PowerPoint 0 12-15-2010 07:44 AM
OFFICE(Word,Excel..)-crash/close when DIALOG BOX launched of insert image,open file buggingme Office 1 05-30-2010 12:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft