software

I have copied a sheet and after I have renamed that sheet I end up with the
prefix .xls] in front of the new name. I have been working with Excel on and
off for a couple of years now but I have never encountered this problem.

The excel spreadsheet that this is happening to is located on another
computer than I originally used to create the sheet. It is also a secured
sheet.

What can I do to remedy this problem?

rename the file.
--
Gary''s Studentquot;Erchamionquot; wrote:

gt; I have copied a sheet and after I have renamed that sheet I end up with the
gt; prefix .xls] in front of the new name. I have been working with Excel on and
gt; off for a couple of years now but I have never encountered this problem.
gt;
gt; The excel spreadsheet that this is happening to is located on another
gt; computer than I originally used to create the sheet. It is also a secured
gt; sheet.
gt;
gt; What can I do to remedy this problem?

Renaming the file does not work.
Do you mean renaming the file or the sheet?
Like i said, renaming the sheet is the problem and renaming the file is not
working either?
What am I doing wrong?

quot;Gary''s Studentquot; wrote:

gt; rename the file.
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Erchamionquot; wrote:
gt;
gt; gt; I have copied a sheet and after I have renamed that sheet I end up with the
gt; gt; prefix .xls] in front of the new name. I have been working with Excel on and
gt; gt; off for a couple of years now but I have never encountered this problem.
gt; gt;
gt; gt; The excel spreadsheet that this is happening to is located on another
gt; gt; computer than I originally used to create the sheet. It is also a secured
gt; gt; sheet.
gt; gt;
gt; gt; What can I do to remedy this problem?

Close excel.
Open windows explorer
Find that file
Rename it.

Remove and [ or ] that you have in the name.

Those []'s cause nothing but trouble in excel.

Erchamion wrote:
gt;
gt; I have copied a sheet and after I have renamed that sheet I end up with the
gt; prefix .xls] in front of the new name. I have been working with Excel on and
gt; off for a couple of years now but I have never encountered this problem.
gt;
gt; The excel spreadsheet that this is happening to is located on another
gt; computer than I originally used to create the sheet. It is also a secured
gt; sheet.
gt;
gt; What can I do to remedy this problem?

--

Dave Peterson

Hi Dave,

I got the same problem of prefix quot;.xls]quot; after renaming the worksheet. I
read your reply here and tried your method by renaming the workbook first.
The problem is solved. There is no more prefixquot;.xls]quot;. Thanks a lot.

I would also like to know what causes this problem.

Thank you for your help.

D Moonn
---------------------------------------------------------------------------------

quot;Dave Petersonquot; wrote:

gt; Close excel.
gt; Open windows explorer
gt; Find that file
gt; Rename it.
gt;
gt; Remove and [ or ] that you have in the name.
gt;
gt; Those []'s cause nothing but trouble in excel.
gt;
gt; Erchamion wrote:
gt; gt;
gt; gt; I have copied a sheet and after I have renamed that sheet I end up with the
gt; gt; prefix .xls] in front of the new name. I have been working with Excel on and
gt; gt; off for a couple of years now but I have never encountered this problem.
gt; gt;
gt; gt; The excel spreadsheet that this is happening to is located on another
gt; gt; computer than I originally used to create the sheet. It is also a secured
gt; gt; sheet.
gt; gt;
gt; gt; What can I do to remedy this problem?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

The cause is those []'s in the file name.

Those brackets mean something special to excel. Create two workbooks and put a
formula refering to the first workbook into the second workbook.

Close and save that first workbook and you'll see how that formula changes to
include the drive and path and how those []'s are used.

Why excel can't do a better job--I don't know.

D Moonn wrote:
gt;
gt; Hi Dave,
gt;
gt; I got the same problem of prefix quot;.xls]quot; after renaming the worksheet. I
gt; read your reply here and tried your method by renaming the workbook first.
gt; The problem is solved. There is no more prefixquot;.xls]quot;. Thanks a lot.
gt;
gt; I would also like to know what causes this problem.
gt;
gt; Thank you for your help.
gt;
gt; D Moonn
gt; ---------------------------------------------------------------------------------
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Close excel.
gt; gt; Open windows explorer
gt; gt; Find that file
gt; gt; Rename it.
gt; gt;
gt; gt; Remove and [ or ] that you have in the name.
gt; gt;
gt; gt; Those []'s cause nothing but trouble in excel.
gt; gt;
gt; gt; Erchamion wrote:
gt; gt; gt;
gt; gt; gt; I have copied a sheet and after I have renamed that sheet I end up with the
gt; gt; gt; prefix .xls] in front of the new name. I have been working with Excel on and
gt; gt; gt; off for a couple of years now but I have never encountered this problem.
gt; gt; gt;
gt; gt; gt; The excel spreadsheet that this is happening to is located on another
gt; gt; gt; computer than I originally used to create the sheet. It is also a secured
gt; gt; gt; sheet.
gt; gt; gt;
gt; gt; gt; What can I do to remedy this problem?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Hi Dave,

Thanks again. I had this problem for about a month, and have read books to
try to solve it, but in vain. You have helped me. I appreciate much for your
help.

Regards,
D Moonn.

---------------------------------------------------------------------------------------------

quot;Dave Petersonquot; wrote:

gt; The cause is those []'s in the file name.
gt;
gt; Those brackets mean something special to excel. Create two workbooks and put a
gt; formula refering to the first workbook into the second workbook.
gt;
gt; Close and save that first workbook and you'll see how that formula changes to
gt; include the drive and path and how those []'s are used.
gt;
gt; Why excel can't do a better job--I don't know.
gt;
gt; D Moonn wrote:
gt; gt;
gt; gt; Hi Dave,
gt; gt;
gt; gt; I got the same problem of prefix quot;.xls]quot; after renaming the worksheet. I
gt; gt; read your reply here and tried your method by renaming the workbook first.
gt; gt; The problem is solved. There is no more prefixquot;.xls]quot;. Thanks a lot.
gt; gt;
gt; gt; I would also like to know what causes this problem.
gt; gt;
gt; gt; Thank you for your help.
gt; gt;
gt; gt; D Moonn
gt; gt; ---------------------------------------------------------------------------------
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Close excel.
gt; gt; gt; Open windows explorer
gt; gt; gt; Find that file
gt; gt; gt; Rename it.
gt; gt; gt;
gt; gt; gt; Remove and [ or ] that you have in the name.
gt; gt; gt;
gt; gt; gt; Those []'s cause nothing but trouble in excel.
gt; gt; gt;
gt; gt; gt; Erchamion wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I have copied a sheet and after I have renamed that sheet I end up with the
gt; gt; gt; gt; prefix .xls] in front of the new name. I have been working with Excel on and
gt; gt; gt; gt; off for a couple of years now but I have never encountered this problem.
gt; gt; gt; gt;
gt; gt; gt; gt; The excel spreadsheet that this is happening to is located on another
gt; gt; gt; gt; computer than I originally used to create the sheet. It is also a secured
gt; gt; gt; gt; sheet.
gt; gt; gt; gt;
gt; gt; gt; gt; What can I do to remedy this problem?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;