+ Reply to Thread
Results 1 to 7 of 7

REF errors when opening excel in xp. works fine when opening wor.

  1. #1
    br
    Guest

    REF errors when opening excel in xp. works fine when opening wor.

    I'm working on a spreadsheet where I receive REF errors when opening it on a
    Windows XP machine. On a Windows 2000 machince it opens properly. I can't
    seem to figure it out.


  2. #2
    Gord Dibben
    Guest

    Re: REF errors when opening excel in xp. works fine when opening wor.

    Couple of potential causes gleaned from Help.

    Using a link to a program that is not running

    Start the program.

    Linking to a Dynamic Data Exchange (DDE) topic such as "system" that is not
    available

    Make sure that you're using the correct DDE topic.


    Gord Dibben Excel MVP



    On Mon, 18 Apr 2005 16:36:03 -0700, "br" <br@discussions.microsoft.com> wrote:

    >I'm working on a spreadsheet where I receive REF errors when opening it on a
    >Windows XP machine. On a Windows 2000 machince it opens properly. I can't
    >seem to figure it out.



  3. #3
    Dave Peterson
    Guest

    Re: REF errors when opening excel in xp. works fine when opening wor.

    xl2002+ likes to recalculate any workbooks that were created in previous
    versions. In earlier versions of excel, if you answer No to the update links
    prompt, the existing values are kept. In xl2002+, you get those errors.

    Jim Rech posted a registry tweak:
    http://groups.google.com/groups?thre...TNGP11.phx.gbl

    Maybe it'll work for you.

    Gord Dibben wrote:
    >
    > Couple of potential causes gleaned from Help.
    >
    > Using a link to a program that is not running
    >
    > Start the program.
    >
    > Linking to a Dynamic Data Exchange (DDE) topic such as "system" that is not
    > available
    >
    > Make sure that you're using the correct DDE topic.
    >
    >
    > Gord Dibben Excel MVP
    >
    >
    > On Mon, 18 Apr 2005 16:36:03 -0700, "br" <br@discussions.microsoft.com> wrote:
    >
    > >I'm working on a spreadsheet where I receive REF errors when opening it on a
    > >Windows XP machine. On a Windows 2000 machince it opens properly. I can't
    > >seem to figure it out.


    --

    Dave Peterson

  4. #4
    Dave Peterson
    Guest

    Re: REF errors when opening excel in xp. works fine when opening wor.

    This was supposed to be a followup to the OP.

    Dave Peterson wrote:
    >
    > xl2002+ likes to recalculate any workbooks that were created in previous
    > versions. In earlier versions of excel, if you answer No to the update links
    > prompt, the existing values are kept. In xl2002+, you get those errors.
    >
    > Jim Rech posted a registry tweak:
    > http://groups.google.com/groups?thre...TNGP11.phx.gbl
    >
    > Maybe it'll work for you.
    >
    > Gord Dibben wrote:
    > >
    > > Couple of potential causes gleaned from Help.
    > >
    > > Using a link to a program that is not running
    > >
    > > Start the program.
    > >
    > > Linking to a Dynamic Data Exchange (DDE) topic such as "system" that is not
    > > available
    > >
    > > Make sure that you're using the correct DDE topic.
    > >
    > >
    > > Gord Dibben Excel MVP
    > >
    > >
    > > On Mon, 18 Apr 2005 16:36:03 -0700, "br" <br@discussions.microsoft.com> wrote:
    > >
    > > >I'm working on a spreadsheet where I receive REF errors when opening it on a
    > > >Windows XP machine. On a Windows 2000 machince it opens properly. I can't
    > > >seem to figure it out.

    >
    > --
    >
    > Dave Peterson


    --

    Dave Peterson

  5. #5
    GoodenowKZC
    Guest

    Re: REF errors when opening excel in xp. works fine when opening

    I've noticed this problem as well. Specifically, I've noticed that if I'm
    referencing a workbook that has 0 values, the program will return #REF! for
    only those cells that have zero values in the closed workbook. Any non-zero
    values will be lost. Have you experienced this problem?

    "Dave Peterson" wrote:

    > xl2002+ likes to recalculate any workbooks that were created in previous
    > versions. In earlier versions of excel, if you answer No to the update links
    > prompt, the existing values are kept. In xl2002+, you get those errors.
    >
    > Jim Rech posted a registry tweak:
    > http://groups.google.com/groups?thre...TNGP11.phx.gbl
    >
    > Maybe it'll work for you.
    >
    > Gord Dibben wrote:
    > >
    > > Couple of potential causes gleaned from Help.
    > >
    > > Using a link to a program that is not running
    > >
    > > Start the program.
    > >
    > > Linking to a Dynamic Data Exchange (DDE) topic such as "system" that is not
    > > available
    > >
    > > Make sure that you're using the correct DDE topic.
    > >
    > >
    > > Gord Dibben Excel MVP
    > >
    > >
    > > On Mon, 18 Apr 2005 16:36:03 -0700, "br" <br@discussions.microsoft.com> wrote:
    > >
    > > >I'm working on a spreadsheet where I receive REF errors when opening it on a
    > > >Windows XP machine. On a Windows 2000 machince it opens properly. I can't
    > > >seem to figure it out.

    >
    > --
    >
    > Dave Peterson
    >


  6. #6
    Dave Peterson
    Guest

    Re: REF errors when opening excel in xp. works fine when opening

    No. But I don't use many workbooks that are linked.

    GoodenowKZC wrote:
    >
    > I've noticed this problem as well. Specifically, I've noticed that if I'm
    > referencing a workbook that has 0 values, the program will return #REF! for
    > only those cells that have zero values in the closed workbook. Any non-zero
    > values will be lost. Have you experienced this problem?
    >
    > "Dave Peterson" wrote:
    >
    > > xl2002+ likes to recalculate any workbooks that were created in previous
    > > versions. In earlier versions of excel, if you answer No to the update links
    > > prompt, the existing values are kept. In xl2002+, you get those errors.
    > >
    > > Jim Rech posted a registry tweak:
    > > http://groups.google.com/groups?thre...TNGP11.phx.gbl
    > >
    > > Maybe it'll work for you.
    > >
    > > Gord Dibben wrote:
    > > >
    > > > Couple of potential causes gleaned from Help.
    > > >
    > > > Using a link to a program that is not running
    > > >
    > > > Start the program.
    > > >
    > > > Linking to a Dynamic Data Exchange (DDE) topic such as "system" that is not
    > > > available
    > > >
    > > > Make sure that you're using the correct DDE topic.
    > > >
    > > >
    > > > Gord Dibben Excel MVP
    > > >
    > > >
    > > > On Mon, 18 Apr 2005 16:36:03 -0700, "br" <br@discussions.microsoft.com> wrote:
    > > >
    > > > >I'm working on a spreadsheet where I receive REF errors when opening it on a
    > > > >Windows XP machine. On a Windows 2000 machince it opens properly. I can't
    > > > >seem to figure it out.

    > >
    > > --
    > >
    > > Dave Peterson
    > >


    --

    Dave Peterson

  7. #7
    oduran
    Guest

    Re: REF errors when opening excel in xp. works fine when opening

    I experience the problem. How did you solve it?

    "GoodenowKZC" wrote:

    > I've noticed this problem as well. Specifically, I've noticed that if I'm
    > referencing a workbook that has 0 values, the program will return #REF! for
    > only those cells that have zero values in the closed workbook. Any non-zero
    > values will be lost. Have you experienced this problem?



+ 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