Solved

Excel file saving

Posted on 2011-09-16
6
339 Views
Last Modified: 2012-05-12
I have two computers, both running W7 and office 2010, on one computer, when I save an excel file that I received say via email, it automatically adds "copy of" to precede the file name by default. like this: "Copy of my spread sheet.xlxs". On the other computer, excel does not add "copy of" but does add underlines between all the words in the file name and a number at the end in paranthesis like this: "my_spread_sheet_(2).xlsx"

I cannot figure out for the life of me where I can change how Excel (or Word) handles default naming of files I am "saving". A few google searches turned up book.xlt in the XLstart folder as the default template for excel but if that is the right place, I still can't find any instructions to change these settings, not to mention that file does not exist on my computer....
0
Comment
Question by:swjtx99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:Arno Koster
ID: 36549028
When you download files from the internet, they will be saved in a 'downloads' folder. Some browsers such as google chrome automatically add (2) when the same file s downloaded again, and (3) / (4) etc for consequtive downloads.

I have not seen the adding of "copy of" before but that should be prevented by using "save as" functionality in excel.
0
 
LVL 2

Expert Comment

by:jan24
ID: 36549385
Akoster is right - this is more likely to be to do with where the file has come from than to do with Excel itself.  Can you give a bit more detail about where the file came from in each of your two computers?
0
 

Author Comment

by:swjtx99
ID: 36554050
These are all mostly my own files or files from my company's network. I don't recall a specific file source as it seems to happen with all files but as an example, one of our software applications on a server sends me a report several times a day into my email. If I retrieve it from my primary comuter (outlook, double click to open in Excel 2010 do a file "save as") and save it, I get the "copy of" added, even though there's not already a file with that name in the directory I am saving it to. If a use the other computer (Webmail/outlook, double click to open in Excel 2010, file "save as") I get al lthe underlines between words of the filename and a number added to the end.

The name of the file as an attachment to the email is named something like "08-16-11 backlog report.xls" so whether I open it from Webmail or directly from outlook, the filename starts out the same. It's just when I open it in excel and do a save as that all this funny stuff starts to happen.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:swjtx99
ID: 36556434
I guess there are no settings for this?
0
 
LVL 19

Accepted Solution

by:
Arno Koster earned 500 total points
ID: 36559476
As far as I know, there are no excel settings for this.
The only way I could think of is when you have macro code (inside of the opened file or as an add-in) running which handles the save as event. This seems a rather long shot however, because for the computers to rename the files in different formats also different macro code should be present.

If this is seena s a big problem, you could concoct an excel add-in containing code to run instead of the regular save as option, stripping the underscores and copy of, and opening the regular save as dialog box with the updated filename

eg.
'-- get original filename
filename = ActiveWorkbook.Name
'-- strip underscores
filename = replace(filename, "_", " ")
'-- strip copy of
if lcase(left(filename,7)) = "copy of" then filename = mid(filename,7)
'-- open save as dialogbox
activeworkbook.SaveAs Application.GetSaveAsFilename(filename)

Open in new window



0
 

Author Comment

by:swjtx99
ID: 36564422
It's not just with Excel but I was hoping it might be an "MS Office" or W7 setting.

After a lot of google searches myself, I thought I'd give it one last shot here. Looks like it really does have everything to do with the origination (source) of the file. I just don't remember having these issues in WXP....
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question