Dear Sir,

I am currently using Excel 2002 in my work place.

Today, I copied a formularized worksheet and converted all formulas to
value before pasting it to a new spreadsheet.

I found that a number of cells have an underline below it. When I put the
cursor on these cells it reads something like this :

" mailto:-@sum('R9'!F12909:F13277) - click once to follow, click and hold to
select this cell "

When I click at this cell, the Internet Explorer keep on opening up to 60-75
windows. I could do anything to stop this.

May I know what might have cause this problem ? How to prevent it from
happening in the future ?

Usually I need to close these Internet Explorer Window one by one in order
to continue working with the worksheet, Is there any short cut to close them
at one go ?


Thanks

Low

--
A36B58K641

When the cell is selected, enter the edit bar to make you formula look like
this:
=sum('R9'!F12909:F13277)
Or you can just delet the contents of the cell and put in the value you need.

"Mr. Low" wrote:

Dear Sir,

I am currently using Excel 2002 in my work place.

Today, I copied a formularized worksheet and converted all formulas to
value before pasting it to a new spreadsheet.

I found that a number of cells have an underline below it. When I put the
cursor on these cells it reads something like this :

" mailto:-@sum('R9'!F12909:F13277) - click once to follow, click and hold to
select this cell "

When I click at this cell, the Internet Explorer keep on opening up to 60-75
windows. I could do anything to stop this.

May I know what might have cause this problem ? How to prevent it from
happening in the future ?

Usually I need to close these Internet Explorer Window one by one in order
to continue working with the worksheet, Is there any short cut to close them
at one go ?


Thanks

Low

--
A36B58K641

Hello,

I cannot edit the cell content as when I click at the cell, the Internet
eXplorer starts to pop up. I cannot delete the cell and enter the values as
the number of cells involved is great.

I suspect this is caused by the activation of the hyperlink functionm, but I
do not know how to deactivate it. The similar problem arises when I click at
a cell that is linked to other worksheets in the same file.

Any suggestion on how to fix this problem from anybody ?


Thanks

Low


--
A36B58K641


"fluffymoore" wrote:

When the cell is selected, enter the edit bar to make you formula look like
this:
=sum('R9'!F12909:F13277)
Or you can just delet the contents of the cell and put in the value you need.

"Mr. Low" wrote:

Dear Sir,

I am currently using Excel 2002 in my work place.

Today, I copied a formularized worksheet and converted all formulas to
value before pasting it to a new spreadsheet.

I found that a number of cells have an underline below it. When I put the
cursor on these cells it reads something like this :

" mailto:-@sum('R9'!F12909:F13277) - click once to follow, click and hold to
select this cell "

When I click at this cell, the Internet Explorer keep on opening up to 60-75
windows. I could do anything to stop this.

May I know what might have cause this problem ? How to prevent it from
happening in the future ?

Usually I need to close these Internet Explorer Window one by one in order
to continue working with the worksheet, Is there any short cut to close them
at one go ?


Thanks

Low

--
A36B58K641

Hold the CTRL button and then select the cell with the hyperlink. You should
be able to edit it then

Dave
--
Brevity is the soul of wit.


"Mr. Low" wrote:

Hello,

I cannot edit the cell content as when I click at the cell, the Internet
eXplorer starts to pop up. I cannot delete the cell and enter the values as
the number of cells involved is great.

I suspect this is caused by the activation of the hyperlink functionm, but I
do not know how to deactivate it. The similar problem arises when I click at
a cell that is linked to other worksheets in the same file.

Any suggestion on how to fix this problem from anybody ?


Thanks

Low


--
A36B58K641


"fluffymoore" wrote:

When the cell is selected, enter the edit bar to make you formula look like
this:
=sum('R9'!F12909:F13277)
Or you can just delet the contents of the cell and put in the value you need.

"Mr. Low" wrote:

Dear Sir,

I am currently using Excel 2002 in my work place.

Today, I copied a formularized worksheet and converted all formulas to
value before pasting it to a new spreadsheet.

I found that a number of cells have an underline below it. When I put the
cursor on these cells it reads something like this :

" mailto:-@sum('R9'!F12909:F13277) - click once to follow, click and hold to
select this cell "

When I click at this cell, the Internet Explorer keep on opening up to 60-75
windows. I could do anything to stop this.

May I know what might have cause this problem ? How to prevent it from
happening in the future ?

Usually I need to close these Internet Explorer Window one by one in order
to continue working with the worksheet, Is there any short cut to close them
at one go ?


Thanks

Low

--
A36B58K641

Right Click on the cell then select edit hyperlink, and select remove link!

"Mr. Low" wrote:

Hello,

I cannot edit the cell content as when I click at the cell, the Internet
eXplorer starts to pop up. I cannot delete the cell and enter the values as
the number of cells involved is great.

I suspect this is caused by the activation of the hyperlink functionm, but I
do not know how to deactivate it. The similar problem arises when I click at
a cell that is linked to other worksheets in the same file.

Any suggestion on how to fix this problem from anybody ?


Thanks

Low


--
A36B58K641


"fluffymoore" wrote:

When the cell is selected, enter the edit bar to make you formula look like
this:
=sum('R9'!F12909:F13277)
Or you can just delet the contents of the cell and put in the value you need.

"Mr. Low" wrote:

Dear Sir,

I am currently using Excel 2002 in my work place.

Today, I copied a formularized worksheet and converted all formulas to
value before pasting it to a new spreadsheet.

I found that a number of cells have an underline below it. When I put the
cursor on these cells it reads something like this :

" mailto:-@sum('R9'!F12909:F13277) - click once to follow, click and hold to
select this cell "

When I click at this cell, the Internet Explorer keep on opening up to 60-75
windows. I could do anything to stop this.

May I know what might have cause this problem ? How to prevent it from
happening in the future ?

Usually I need to close these Internet Explorer Window one by one in order
to continue working with the worksheet, Is there any short cut to close them
at one go ?


Thanks

Low

--
A36B58K641

Yes, It works

Many Thanks

Low
--
A36B58K641


"Dave F" wrote:

Hold the CTRL button and then select the cell with the hyperlink. You should
be able to edit it then

Dave
--
Brevity is the soul of wit.


"Mr. Low" wrote:

Hello,

I cannot edit the cell content as when I click at the cell, the Internet
eXplorer starts to pop up. I cannot delete the cell and enter the values as
the number of cells involved is great.

I suspect this is caused by the activation of the hyperlink functionm, but I
do not know how to deactivate it. The similar problem arises when I click at
a cell that is linked to other worksheets in the same file.

Any suggestion on how to fix this problem from anybody ?


Thanks

Low


--
A36B58K641


"fluffymoore" wrote:

When the cell is selected, enter the edit bar to make you formula look like
this:
=sum('R9'!F12909:F13277)
Or you can just delet the contents of the cell and put in the value you need.

"Mr. Low" wrote:

Dear Sir,

I am currently using Excel 2002 in my work place.

Today, I copied a formularized worksheet and converted all formulas to
value before pasting it to a new spreadsheet.

I found that a number of cells have an underline below it. When I put the
cursor on these cells it reads something like this :

" mailto:-@sum('R9'!F12909:F13277) - click once to follow, click and hold to
select this cell "

When I click at this cell, the Internet Explorer keep on opening up to 60-75
windows. I could do anything to stop this.

May I know what might have cause this problem ? How to prevent it from
happening in the future ?

Usually I need to close these Internet Explorer Window one by one in order
to continue working with the worksheet, Is there any short cut to close them
at one go ?


Thanks

Low

--
A36B58K641

Yes, It works

Many Thanks

Low

--
A36B58K641


"fluffymoore" wrote:

Right Click on the cell then select edit hyperlink, and select remove link!

"Mr. Low" wrote:

Hello,

I cannot edit the cell content as when I click at the cell, the Internet
eXplorer starts to pop up. I cannot delete the cell and enter the values as
the number of cells involved is great.

I suspect this is caused by the activation of the hyperlink functionm, but I
do not know how to deactivate it. The similar problem arises when I click at
a cell that is linked to other worksheets in the same file.

Any suggestion on how to fix this problem from anybody ?


Thanks

Low


--
A36B58K641


"fluffymoore" wrote:

When the cell is selected, enter the edit bar to make you formula look like
this:
=sum('R9'!F12909:F13277)
Or you can just delet the contents of the cell and put in the value you need.

"Mr. Low" wrote:

Dear Sir,

I am currently using Excel 2002 in my work place.

Today, I copied a formularized worksheet and converted all formulas to
value before pasting it to a new spreadsheet.

I found that a number of cells have an underline below it. When I put the
cursor on these cells it reads something like this :

" mailto:-@sum('R9'!F12909:F13277) - click once to follow, click and hold to
select this cell "

When I click at this cell, the Internet Explorer keep on opening up to 60-75
windows. I could do anything to stop this.

May I know what might have cause this problem ? How to prevent it from
happening in the future ?

Usually I need to close these Internet Explorer Window one by one in order
to continue working with the worksheet, Is there any short cut to close them
at one go ?


Thanks

Low

--
A36B58K641