+ Reply to Thread
Results 1 to 2 of 2

The reference is not valid error message for data - but the same ones appear to exist

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    46

    The reference is not valid error message for data - but the same ones appear to exist

    I will attach a copy of a chart I use for flow testing fire pumps. The data series for "Previous" and "MFG" work fine but the data for "Current Test Data" has the X and Y value series backwards. When I try to edit them to reverse this I get the error message in the subject line, yet the data seems correct.

    I'm sure I've run into this and solved it before but it's really got me baffled right now.Flow Test Example.xlsx

  2. #2
    Forum Contributor
    Join Date
    02-22-2011
    Location
    Rhône Alpes, France
    MS-Off Ver
    Excel 2007
    Posts
    201

    Re: The reference is not valid error message for data - but the same ones appear to e

    Hi,
    The data in column L and O are reversed
    Net pump pressure (PSI) : 74, 71, 60 instead of 0, 300, 450
    Flow (GPM) : 0, 300, 450 instead of 74, 71, 60
    Hope this helps
    Best regards

+ 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