+ Reply to Thread
Results 1 to 2 of 2

External cell reference not working! (Excel 2013)

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    External cell reference not working! (Excel 2013)

    Hi guys,

    I have a log I work in that I reference cells from other work sheets (in this case change orders). I externally reference in important data ($ by cost type), however, one cell from the sources consistently doesn't work. Instead of showing the value of the cell, it just shows the source/external reference formula. Here is a snip, the cell I am referring to is B12:

    excel cell B12.PNG


    Any help would be much appreciated!

    Thanks,

    Michon

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: External cell reference not working! (Excel 2013)

    What is the Format type for that cell? If it is Text, then change it to General, double-click on the cell, then hit ENTER.

    BTW images are rarely helpful. If my suggestion does not resolve your problem then I suggest you attach your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2013 and Access 2013 as Pivot Table External Data Source
    By Grimnebulin in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-27-2015, 02:13 PM
  2. Replies: 1
    Last Post: 12-27-2014, 11:20 PM
  3. Replies: 2
    Last Post: 08-04-2012, 11:28 AM
  4. Replies: 0
    Last Post: 05-24-2011, 12:33 AM
  5. Excel 2007 : Working with external reference links
    By rleonard in forum Excel General
    Replies: 3
    Last Post: 03-17-2011, 04:27 PM
  6. Replies: 3
    Last Post: 05-13-2009, 11:51 PM
  7. Replies: 2
    Last Post: 05-01-2009, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1