Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

sheet version control  I've got one xtra

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Excel-General - 18 Jan 2008 18:36 GMT
Thank God for google groups.  I used to be able to send email from
Firefox to the list.  I dont' know what is going on.

I have a sheet I'm writing some vba modules for.  I don't know how I
did this but I now have myspreadsheet.xls and another
myspreadsheet(version1).xls.  Every time I open the one sheet they
both pop up.  How do I get rid of the wrong one?  I've been closing
the wrong one but that isn't solving anything.

Thanks,
Gord Dibben - 18 Jan 2008 22:55 GMT
Do you see myspreadsheet.xls:1 and myspreadsheet.xls:2?

You have two windows open with the same file in both.

Close one of them without saving, then save the remaining.

Gord Dibben  MS Excel MVP

>Thank God for google groups.  I used to be able to send email from
>Firefox to the list.  I dont' know what is going on.
[quoted text clipped - 6 lines]
>
>Thanks,
Excel-General - 19 Jan 2008 01:54 GMT
I closed all the file windows, and closed excel.  Then I opened the
one sheet, there are still 2 workbooks.  Myspreadsheet.xls and
myspreadsheet(version1).xls.  I really am just using the version1
sheet how can I get rid of the first one?  I noticed there are two
similar projects in the VBA window.  I tried saving my file and then
deleting the extra project and Excel wouldn't let me.  Most of the
commands are dimmed out and I didn't see a delete.  How do you delete
an extra project?
thanks again,
> Do you see myspreadsheet.xls:1 and myspreadsheet.xls:2?
>
[quoted text clipped - 14 lines]
>
> >Thanks,
Bernard Liengme - 19 Jan 2008 19:50 GMT
It sounds as if Excel did an AutoSave and now you have that and the original
file in your folder. Try deleting (or to be save, renaming) the file with
Version in its name.
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Thank God for google groups.  I used to be able to send email from
> Firefox to the list.  I dont' know what is going on.
[quoted text clipped - 6 lines]
>
> Thanks,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.