+ Reply to Thread
Results 1 to 2 of 2

YValues in Dynamic Chart changing to =[0]!

  1. #1
    Registered User
    Join Date
    07-30-2009
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003, 2007, and Mac 2008
    Posts
    10

    Question YValues in Dynamic Chart changing to =[0]!

    I wonder if anyone has had this problem?

    I've got a couple of dynamic charts that break every time I close and open the file. When I close, the YVales read "solar.xlsx!dynLoadVoltage" under the "Select Data Source" window.

    When I reopen the file, they've changed to "=[0]!dynLoadVoltage" and they no longer update when the data changes.

    I've attached the file for reference.
    Any suggestions?

    Thanks for reading!
    Attached Files Attached Files
    Last edited by agrajag42; 09-09-2009 at 03:09 PM.

  2. #2
    Registered User
    Join Date
    07-30-2009
    Location
    Boston, MA
    MS-Off Ver
    Excel 2003, 2007, and Mac 2008
    Posts
    10

    Re: YValues in Dynamic Chart changing to =[0]!

    Interestingly, I built this in Excel 2008 for Mac, which is where I'm seeing the problem. When I look at the same file on Excel 2007 on my PC, it works.

    So the problem must be a glitch in Office for Mac.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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