Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 181
Default linking sheets in a workbook

when I try to link cells on different sheets from the same workbook it doesnt
seem to work properly. In the new cell which i want to display info from
another work sheet so I type:

='AB-Info'!B50

And the formula stays in my new cell. When it should be the words from the
original cell.

Any tips?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default linking sheets in a workbook

Either you have the "formula view" enabled:
<Tools. <Options <View tab
With "Formulas" *CHECKED* under 'Windows Options'.

OR

The cell that you used to enter your formula into was formatted as "text"
before you entered the formula.
Just changing the format to 'General' or 'Number' will not work.
You must re-enter (register) the formula again.
Change the format to number or general, then click in the formula bar and
hit <Enter.

A shortcut for this revision is to select the cell, then:
<Ctrl <Shift < ~ ,
Then <F2,
Then <Enter.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



Try this:

"Curtis" wrote in message
...
when I try to link cells on different sheets from the same workbook it
doesnt
seem to work properly. In the new cell which i want to display info from
another work sheet so I type:

='AB-Info'!B50

And the formula stays in my new cell. When it should be the words from
the
original cell.

Any tips?

Thanks


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 181
Default linking sheets in a workbook

Thanks very much!

The second solution fixed my problem.

Much appriciated!

Curtis

"RagDyer" wrote:

Either you have the "formula view" enabled:
<Tools. <Options <View tab
With "Formulas" *CHECKED* under 'Windows Options'.

OR

The cell that you used to enter your formula into was formatted as "text"
before you entered the formula.
Just changing the format to 'General' or 'Number' will not work.
You must re-enter (register) the formula again.
Change the format to number or general, then click in the formula bar and
hit <Enter.

A shortcut for this revision is to select the cell, then:
<Ctrl <Shift < ~ ,
Then <F2,
Then <Enter.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



Try this:

"Curtis" wrote in message
...
when I try to link cells on different sheets from the same workbook it
doesnt
seem to work properly. In the new cell which i want to display info from
another work sheet so I type:

='AB-Info'!B50

And the formula stays in my new cell. When it should be the words from
the
original cell.

Any tips?

Thanks



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default linking sheets in a workbook

Sounds like the new cells are formatted as Text.

Re-format to General then F2ENTER on your formula cell(s)


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 13:14:02 -0700, Curtis
wrote:

when I try to link cells on different sheets from the same workbook it doesnt
seem to work properly. In the new cell which i want to display info from
another work sheet so I type:

='AB-Info'!B50

And the formula stays in my new cell. When it should be the words from the
original cell.

Any tips?

Thanks


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default linking sheets in a workbook

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Curtis" wrote in message
...
Thanks very much!

The second solution fixed my problem.

Much appriciated!

Curtis

"RagDyer" wrote:

Either you have the "formula view" enabled:
<Tools. <Options <View tab
With "Formulas" *CHECKED* under 'Windows Options'.

OR

The cell that you used to enter your formula into was formatted as "text"
before you entered the formula.
Just changing the format to 'General' or 'Number' will not work.
You must re-enter (register) the formula again.
Change the format to number or general, then click in the formula bar and
hit <Enter.

A shortcut for this revision is to select the cell, then:
<Ctrl <Shift < ~ ,
Then <F2,
Then <Enter.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



Try this:

"Curtis" wrote in message
...
when I try to link cells on different sheets from the same workbook it
doesnt
seem to work properly. In the new cell which i want to display info
from
another work sheet so I type:

='AB-Info'!B50

And the formula stays in my new cell. When it should be the words from
the
original cell.

Any tips?

Thanks




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA Amaxwell Excel Worksheet Functions 4 August 17th 06 06:23 AM
linking cell value to specific worksheet in the same workbook lester Excel Discussion (Misc queries) 0 July 27th 06 10:56 AM
Rescuing Sheets in Corrupt Workbook Michael Link Excel Discussion (Misc queries) 4 July 24th 06 07:05 PM
Linking 3 closed worksheets to master workbook template fabiano Excel Worksheet Functions 1 March 22nd 06 06:49 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 09:13 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"