Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nia
 
Posts: n/a
Default External Link Shows Formula Not Info


I apologize iof this is answered somewhere already, but I can't find
it.

I'm using the info in a worksheet to populate the cells in another. I
use the appropriate formula to reference the worksheet ie.
=Sheet1!A46. It works in some cells but in others it simply displays
the formula itself. The cells are formatted the same whether it be
text, number, currency, etc.

Any ideas would be greatly appreciated.


--
nia
------------------------------------------------------------------------
nia's Profile: http://www.excelforum.com/member.php...o&userid=29334
View this thread: http://www.excelforum.com/showthread...hreadid=490482

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default External Link Shows Formula Not Info

Hi!

Those cells are formatted as text.

Select the cells in question
Goto FormatCellsNumberGENERALOK

With those cells still selected
Goto EditReplace
Find what: =
Replace with: =
Replace All

Biff

"nia" wrote in message
...

I apologize iof this is answered somewhere already, but I can't find
it.

I'm using the info in a worksheet to populate the cells in another. I
use the appropriate formula to reference the worksheet ie.
=Sheet1!A46. It works in some cells but in others it simply displays
the formula itself. The cells are formatted the same whether it be
text, number, currency, etc.

Any ideas would be greatly appreciated.


--
nia
------------------------------------------------------------------------
nia's Profile:
http://www.excelforum.com/member.php...o&userid=29334
View this thread: http://www.excelforum.com/showthread...hreadid=490482



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nia
 
Posts: n/a
Default External Link Shows Formula Not Info


Thank you so much! this has been bugging me for months. Thanks so much!
What a great forum. I'm sure I'll be back. :)


--
nia
------------------------------------------------------------------------
nia's Profile: http://www.excelforum.com/member.php...o&userid=29334
View this thread: http://www.excelforum.com/showthread...hreadid=490482

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default External Link Shows Formula Not Info

this has been bugging me for months.

Don't wait so long the next time you have a question or problem!

Thanks for the feedback!

Biff

"nia" wrote in message
...

Thank you so much! this has been bugging me for months. Thanks so much!
What a great forum. I'm sure I'll be back. :)


--
nia
------------------------------------------------------------------------
nia's Profile:
http://www.excelforum.com/member.php...o&userid=29334
View this thread: http://www.excelforum.com/showthread...hreadid=490482



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
How do I use a cell value as the filename in an external link? wattkisson Excel Discussion (Misc queries) 5 July 11th 05 09:07 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Can I link Contact info into an Excel doc? brownbag_dab Excel Worksheet Functions 0 April 28th 05 08:55 PM
External link using calculated cell value Doug Excel Worksheet Functions 1 March 15th 05 09:05 AM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 11:18 PM


All times are GMT +1. The time now is 12:48 AM.

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"