XL 2000 Changes File Name for Save

When I save my Excel spreadsheet, Excel adds a 1 to the
file name (file.xls becomes file1.xls). When I remove the 1
and save it, it responds with the overwrite message? It
just started doing this several weeks ago and I can't
figure out why. Anyone know what's going on?
0
sallgood (2)
10/14/2003 1:40:16 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
715 Views

Similar Articles

[PageSpeed] 11

Are you sure that the additional 1 is added when you're doing the save?

Could it have been added when you were opening the workbook?  If you try it
again, do you see:  File1 (instead of File.xls) in the title bar?

If yes, then it sounds like you've opened the file via a double click in windows
explorer.  And windows told excel to use this file as a template for a new
workbook.

You can check by rightclicking on the file in windows explorer--you'll see the
context popup menu and one of the items will be bold.  If it's Open, then I'm
all wet.  If it's New, then we found the problem.

And if we did find the problem, you can try to reset the default behavior for
double clicking by:

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.

=====
I don't have a guess if it's not this problem.

Sam Allgood wrote:
> 
> When I save my Excel spreadsheet, Excel adds a 1 to the
> file name (file.xls becomes file1.xls). When I remove the 1
> and save it, it responds with the overwrite message? It
> just started doing this several weeks ago and I can't
> figure out why. Anyone know what's going on?

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
10/14/2003 10:38:57 PM
Thanks, Dave, that's helpful. Though your analysis was 
correct (it is defaulting to New), the solution did not 
work. I even tried rebooting after executing the 2 
commands, but the default is still set to New. With the 
second command, it indicated it was installing Execl SR-1 
Profession, so I'm wondering if it might be something 
that SR-1 did.
0
anonymous (74717)
10/15/2003 5:22:00 PM
Also downloaded and installed SR-3. Still no change
>-----Original Message-----
>Thanks, Dave, that's helpful. Though your analysis was 
>correct (it is defaulting to New), the solution did not 
>work. I even tried rebooting after executing the 2 
>commands, but the default is still set to New. With the 
>second command, it indicated it was installing Execl SR-
1 
>Profession, so I'm wondering if it might be something 
>that SR-1 did.
>.
>
0
sallgood (2)
10/15/2003 6:30:55 PM
I use win98 and I can change the default behavior manually by:

Under Windows Explorer
View|Folder Options|File Types Tab
Scroll down to Microsoft Excel Worksheet (extension XLS)
Click on Edit
Make sure that Actions is set to Open (not New)

(I was hoping /unregserver and /regserver would fix this.  (I think it's easier
and safer.))

anonymous@discussions.microsoft.com wrote:
> 
> Thanks, Dave, that's helpful. Though your analysis was
> correct (it is defaulting to New), the solution did not
> work. I even tried rebooting after executing the 2
> commands, but the default is still set to New. With the
> second command, it indicated it was installing Execl SR-1
> Profession, so I'm wondering if it might be something
> that SR-1 did.

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
10/15/2003 10:00:36 PM
Reply:

Similar Artilces:

Outlook 2000 and RPC over HTTP?
Is RPC over HTTP supported by Outlook 2000? Is RPC over HTTP supported by Exchange Server prior to 2003 (i.e., 2000, 5.5)? Or, another way to ask: Must I use Exchange Server 2003, and Outlook 2003 to accomplish RPC over HTTP? Thanks, Thomas PS: Most webcast and literature state things a in way where I think the answer is 2003 only (for both OL and Exch), but it would be nice if a KB article said "not support" on prior version. FYI. Unless, of course, it's support on those version in which case I'd say that doesn't come across.... ahh, ain't marketing literature w...

Help old files and opening them
Hi. I have a file that is from Publisher for Win 95 ver 5. It won't open in Pub98 which is the latest I have and I can't get it resent as the author has passed away. Is there any way I can open this file? TIA Trev --- Outgoing mail is certified Virus Free by AVG but the sender recommends that you enable Email virus scanning on your own machine in case of infection on route. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.675 / Virus Database: 437 - Release Date: 02/05/2004 --- Outgoing mail is certified Virus Free by AVG but the sender recommends that you ...

Autoedit case change "i"
I have several applications which use the low case letter "i" as a code rather than a pronoun. Sometimes but not always Excel changes the lower case "i' to a uppercase "I" . How do I turn off this feature? Josh Hi Josh! Use: Tools > Autocorrect Options Pan down the list to i and delete it OK -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "josh" <josqb@cinci.rr.com> wrote in message news:%23dE5kDH%23DHA.2368@...

Saving Pages
I am new to Publisher and was wondering if a person has saved 12 pages of a book they are working on - is it possible to pull out one of those pages to e-mail to someone for editing and then also re-insert it when returned without having to send the entire 12 pages each time? Is there some way to save invidivual pages to different locations? I am using Publisher 2000 Sp-3, thank you for an info you may be able to give. I did try copy and paste but the graphics did not copy/paste over. The graphics used where from the Publisher CD. You can open Publisher more than one time. Open Publi...

Event Viewer>System>file corrupted
Using XP Home and when I try to clear the entries inthe 'System',itsay the eventfileis corrupted and there is a 'red cross' over the 'system' branch. Although the pc seems to work ok, obviously, there is soething wrong so how do I get rid of the 'red cross'. Thanks =?Utf-8?B?c2hlcnJ5YnVraXQ=?= <sherrybukit@discussions.microsoft.com> wrote in news:5EDB30F5-1F16-4518-BF92-663C29E9F830@microsoft.com: > > Using XP Home and when I try to clear the entries inthe > 'System',itsay the eventfileis corrupted and there is a 'red ...

excel 2000 #18
how can i compare two workbooks in excel 2000 Depends on what you mean? If you meant how can you compare two worksheets in xl2k, then you could do a cell by cell comparison (a1 with A1, x92 with x92). Myrna Larson and and Bill Manville wrote a macro that does this. http://www.cpearson.com/excel/whatsnew.htm look for compare.xla ====== Depending on what you're doing, this might work too. Save each worksheet as .csv files. These files are plain text. You could use MSWord's compare to help find the differences in values. esw wrote: > > how can i compare two workbooks in...

Cannot Output .MDI Files
I cannot seem to find a solution yet even after searching the web. I am able to view .tif and .mdi files through the Microsoft Office Document Image Viewer. I am able to output a .tif file when I have the printing preferences setup to that. However, when I try to output a .mdi file, Office asks where to save as, it then spools, but then disappears. It doesn't save on the desktop (or other folders selected). Do you know where the issue is? ...

Access 2000 DB import tables in SQL Server 2000 DB
I inherited an Access 2000 database that needs to have tables imported into a SQL Server 2000 new database. The Access database has approximately 30 tables. The Access database has approximately 10 forms, 10 reports, and 10 modules. I would like to import Access database tables into the new SQL Server database. After the tables has been imported I will create the relationship between the tables. Next I will create the indexes and link the SQL Server tables to Access database. I know Access 2000 upsizing will complete this procedure but it must have SQL Server v7.0 or v6.X database....

Crystal Report not found on File Repository Server
I recently upgraded our MSCRM server to a new server. We don't typically use the internal CRM reports, we have some custom ones created with PowerTrack that we primarily use. The CEO tried today though to open one of the canned MSCRM reports and got this error message. I tried the others and I get it on all of them. CrystalReportViewer File frs://Input/a_063/021/000/5439/6ac34043c58b1112.rpt not found on File Repository Server. I checked the input folder in c:\program files\crystal ent 9\filestore\input and it is empty. I would have copied them from the old server, but it is ...

Organisation forms location in outlook 2000
Hi, I would like to find out where are the organisation forms stored on Exchange 2003 and i am using Outlook 2000 at the moment. Thank you. Rgds, Sandra http://support.microsoft.com/default.aspx?scid=kb;en-us;821922 might be helpful. "Sandra" <sandra.yeow@nmg-group.com> wrote in message news:427c01c42b68$5116ac10$a301280a@phx.gbl... > Hi, > > I would like to find out where are the organisation forms > stored on Exchange 2003 and i am using Outlook 2000 at the > moment. Thank you. > > Rgds, > Sandra ...

changing default language in XL
I know this probably sounds completely stupid, but i have a swedish version of XL and want to change it to English, as well as not understanding swedish, i am not 100 percent on computers. can someone please help? Thanks Pete. I don't think you can. I think you have to buy the English version... ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "peter curran" <petercurran17@eircom.net> wrote in message news:cUiIf.5957$j7.214198@news.indigo.ie... >I know this probably sounds completely ...

Autocorrect shared in Office 2000
My boss uses AUTO Correct extensively - he types "QU" and it autocorrects that with our company logo. He wants to use this same autocorrect database in Excel, Powerpoint, etc. He gets mad at ME because I don't know. Does anyone know if this is possible to do - share the autocorrect macro/database? THANKS! Cory Autocorrect is already globally shared by Office components. Look for a *.ACL file on the computer or network. Note where it/they is are. Perhaps boss is not accessing the proper file. Add a few things to his autocorrect list and see which *.ACL file updates. ...

Outlook 2000 will not print certain emails
A customer has a problem with Outlook 2000. Certain emails in her Inbox will not print, whereas others will. I cannot see a common factor for the ones that fail, in terms of format (TXT or HTML) or presence/absence of attachment. All emails display OK in Print Preview. The symptom is that when you do File | Print, which displays the Printing Emails dialog box, the (default) printer is greyed out, as are the Page Setup and Define Styles buttons. This is with the Memo Style layout selected; if I change to Table Style, the printer and buttons become enabled. If I press Print with Memo St...

Difficulty opening files with Excel
I have Excel set as my default program for opening .text and .txt files, but when I double-click on the files, nothing happens. Excel doesn't open and my files don't open. I'm using Vista and Office 2007. You can change the format of the text files by "opening" the text file, clicking save as, and then on the save as dialog box, click on "save as type". There should be a file type option that allows you to open that file as an excel fine if it is set the way you said it was. Hope this was helpful to you. "Sandy5590" wrote: ...

publisher 2000 #10
i have talked to hp tech and they said that i need to contact publisher. my problem has to do with no being able to print correctly to a laserjet 4500 color printer. everytime i try i recieve a 49 error which is a firmware error. hp said it has something to do with the publisher. This from http://fixyourownprinter.com/printer/new/15158.html 49.XX PRINTER ERROR A firmware error occurred 1. Press CANCEL JOB to clear the print job from the printer memory. 2. Turn the printer off, and then turn the printer on. 3. Try printing a job from a different software application. If the job prin...

Change picture background on a form on afterupdate event
Hi Folks Hope someone can help on this. I have a form that where I want the picture background to change on the afterupdate event of a field, eg where if the case status is - closed, live, or pending, the backgrounds will change to blue, red or green for example. I have created a table called TBL Backgrounds, with 3 OLE image records and the imageID is the PK. I also have a corresponding form to insert the jpeg. There will only ever be 3 image records in this table. Blue imageID =1 Red imageID= 2 Green imageID=3 I want to be able to change another forms picture by referencing the appropri...

Excel 2000 #9
Is there a way to change the date format in footers and headers.?.these two items do not seem to pick up the formatting specified for the individual cells. David H. David Excel in any version uses the Short Date format from Windows Regional settings in headers/footers. You can make some minor changes in Regional settings but not too much. How about a macro to add the date in any format you choose? Sub DateInFooter() With ActiveSheet .PageSetup.CenterFooter = Format(Date, "dddd, mmmm-dd-yyyy") End With End Sub Gord Dibben MS Excel MVP On Tue, 5 Feb 2008...

Rules in Outlook 2000 #2
Hi all, Our company has recently upgraded our mail server to Exchange 2003 (I am = unsure of the previous version). The staff are running a mixture of Outlook 2003 and = Outlook 2000. For some of the outlook 2000 clients, the rules seem to be getting 'lost' = whenever either the client machine or the email server is rebooted. After this, = going to the Rules Wizard displays a message stating the the client and the server rule = versions are different, and which to use. Selecting to use the Client option always = restores the users rules, but this is only a workaround. None of the ...

XL 03 vs XL 97
Is the newer version of XL that much better than 97? I have a copy of Office '03 Student and Teacher edition, but have never bothered to install it. Are the improvements in it actually worth the effort to mess with it? There are several improvements, but not very spectacular ones. The next version of Excel (due late 2006) will be the biggest change since many years. See http://blogs.msdn.com/excel/default.aspx -- Kind regards, Niek Otten "Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message news:wNednQFttM0wajreRVn-rw@comcast.com... > Is ...

Hyperlinks won't update after website is saved and "published for
I am having trouble afte I save my In web preview, the changed links remain the old ones. What do I do? ...

XL 2000 templates non-operative w/XL 2003?
One of my users just moved some templates from an old machine to a new one. They were created in Excel 2000 and worked fine. In Excel 2003, he hits File, New, sees the list of templates, but when he tries to open any of them, nothing happens. No error message, just nothing. Is the older template format incompatible with Excel 2003? "Doug Kanter" <ancientangler@hotmail.com> wrote in message news:_dNFe.2398$cg.69@news02.roc.ny... > One of my users just moved some templates from an old machine to a new > one. They were created in Excel 2000 and worked fine. In Exc...

missing commas when saving excel as CSV
Hi, I have a very strange symptom that occurs when saving a CSV file from excel. Say the first row has 2 columns and the next 20 rows have only a value entered into the first column but not the second. When I save this file as CSV, the first row obviously has a comma between the two values, and the next 15 correctly have a comma after the value (to indicate that the second column is empty). However, the 16th and subsequent rows have no comma. since I'm trying to parse the file with PHP this is a right royal PITA. anyone know why it's happening or if there is a workaround? (BTW I'...

Excel 2000 and Importing huge ASCII files
Hello, I would like to load a big ascii file into Excel and split it into different worksheets within the same workbook. The criteria to split is an empty line with the next line being 1.0 In total the files contains 147 entities. Anybody who could help me with VBA code? -- Goran Stjepanovic ===================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== Goran, Try the sub below. HTH, Bernie MS Excel MVP Sub...

Change Start Up options at Start Up
Access 2000/2003 While developing a database I leave the various tick boxes in the StartUp form enabled so that I have all menus, etc active. Each time I deploy the .mde database file to the customer I disable some options, primarily 'Allow Full Menus' and 'Allow Toolbar/Menu Changes' (if I remember to). What I would like to do is disable the menu options automatically when the program starts if the file type is .mde and leave them enabled if the file type is .mdb. I found some code at :- http://msdn2.microsoft.com/en-us/library/aa200349 which toggles the StartUp tick boxe...

Publisher 2000 #14
I just upgraded from Windows Me to Windows XP Home Edition. Everything went well, however, I can't open my old Publisher 2000 files. I can create new files but when I try to open an old file, the program crashes. Any assistance would be greatly appreciated. Try opening the old files in safe mode. If they open, update your printer/graphics drivers. Publisher is more critical about printer drivers. -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.mvps.org/msauer/ news://msnews.microsoft.com "Julian" <anonymous@discussions.microsoft.com> wrote in message n...