+ Reply to Thread
Results 1 to 3 of 3

reference errors linking to other workbooks

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327

    reference errors linking to other workbooks

    Hi All,
    I have a co-worker who created a spreadsheet with several worksheets and lots of formulas dealing with net pay. He asked me the other day as to why his spreadsheet won't work on one computer and works fine on another. Most of our work sites have at least 2 computers, Win XP Pro, Office 2003 Pro. He created the spreadsheet on computer A, when he tries to open it on computer B - at the same work location, he gets lot's of !REF errors. Macros security is set to Low. He sent me the spreadsheet, I get the same errors.

    Any ideas why??

    Thanx...LT

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481
    It sounds like the workbook has links to another workbook, but since the other computer does not have the workbook there will be reference errors

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Macros security is set to Low.
    That is an invitation to deep heartbreak.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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