Results 1 to 2 of 2

Thread: REF! error when referencing another worksheet

  1. #1

    REF! error when referencing another worksheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am trying to reference cells in two other worksheets, for just a simple subtraction. In the picture I attached, I've typed in =MaterialsDist!b14-MaterialsRem!b15

    I feel like this should work, but every time I hit enter the box pops up telling me to "update values," and prompting me to pick a file. I don't know why this is happening, or what I am supposed to pick. If I just hit cancel, I get the !Ref error.

    (FYI The tabs previously had different names, with spaces in them. I right-clicked to rename them with no spaces. I also resaved the whole workbook under a different name with no spaces. I'm not sure if that makes a difference.)

    Thanks!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Excel help.jpg 
Views:	14 
Size:	94.1 KB 
ID:	4092  

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013

    update values: worksheet

    Quote Originally Posted by Kalibasa View Post
    every time I hit enter the box pops up telling me to "update values," and prompting me to pick a file.
    Try
    Code:
    ='MaterialsDist'!B14-'MaterialsRem'!B15
    or look here or here
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Tags for this Thread

Posting Permissions

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