worksheet name in workbook

aharris · Apr 23rd, 2002, 06:40 PM

I have several worksheets in my spreadsheet. Cells from each worksheet are used on calculations in the other sheets. I originally named one of the sheets "PV Calc". It is now showing as .xls]PV Calc. Why is it doing this? It has changed three of my sheet names. It will not allow me to change it back either.

Qroozn · Apr 23rd, 2002, 07:03 PM

try copying the entire sheet (select the tab and copy), and then rename the sheet to the original name.

aharris · Apr 23rd, 2002, 07:13 PM

[Thanks - that worked. Any idea what I did to cause that - it has happened a time or two before.]
On 2002-04-23 18:03, Qroozn wrote:
try copying the entire sheet (select the tab and copy), and then rename the sheet to the original name.
[/quote]

Qroozn · Apr 23rd, 2002, 07:16 PM

i couldnt tell you the cause.
you may find that you tried to open up a non-excel application. and the sheet has saved the .xls as its file type for reading.
else it just goes back into the EXCEL X-files

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 06:40 PM	#1
aharris New Member Join Date: Apr 2002 Posts: 2	I have several worksheets in my spreadsheet. Cells from each worksheet are used on calculations in the other sheets. I originally named one of the sheets "PV Calc". It is now showing as .xls]PV Calc. Why is it doing this? It has changed three of my sheet names. It will not allow me to change it back either.

Apr 23rd, 2002, 07:03 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	try copying the entire sheet (select the tab and copy), and then rename the sheet to the original name.

Apr 23rd, 2002, 07:13 PM	#3
aharris New Member Join Date: Apr 2002 Posts: 2	[Thanks - that worked. Any idea what I did to cause that - it has happened a time or two before.] On 2002-04-23 18:03, Qroozn wrote: try copying the entire sheet (select the tab and copy), and then rename the sheet to the original name. [/quote]

Apr 23rd, 2002, 07:16 PM	#4
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	i couldnt tell you the cause. you may find that you tried to open up a non-excel application. and the sheet has saved the .xls as its file type for reading. else it just goes back into the EXCEL X-files