Dynamic charts with named range Windows 8.1

Discussion in 'Excel Charting' started by ji.laras@gmail.com, Apr 13, 2014.

  1. Guest

    Hi

    I have this file working fine for years with Dynamic charts using named ranges in Excel 2007 and Windows 7.

    If I use same file in another pc Excel 2007 but windows 8.1 this is what happens:

    The chart is not working anymore because the named ranges lost their reference to the workbook, let me explain:

    In the chart the x values are referenced as: ='myworkbook.xlsx'!chtX, similarly the y values are ='myworkbook.xlsx'!chtY

    When I open the file in the pc windows 8.1 I see that appears now:
    =[0]!chtX and =[0]!chtY and then the chart is frozen.

    If I correct those references ('myworkbook.xlsx'!chtX...) , it works again... then save the book, exit Excel, open again and voila, the refereneces are again lost and I have again =[0]!chtX and =[0]!chtY

    Any idea what it wrong? the only difference as far as I know is that the pc with the problem is running windows 8.1

    Thanks for your time
     
    , Apr 13, 2014
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. z.entropic
    Replies:
    2
    Views:
    113
    z.entropic
    May 20, 2005
  2. bountifulgrace

    Dynamic Named Range

    bountifulgrace, Apr 6, 2006, in forum: Excel Charting
    Replies:
    1
    Views:
    85
    Don Guillett
    Apr 6, 2006
  3. Milo

    Make dynamic charts more dynamic

    Milo, Apr 12, 2006, in forum: Excel Charting
    Replies:
    1
    Views:
    167
    Andy Pope
    Apr 12, 2006
  4. Can't chart dynamic named range??

    , Jul 20, 2006, in forum: Excel Charting
    Replies:
    4
    Views:
    120
  5. Replies:
    4
    Views:
    104
  6. robert2b
    Replies:
    0
    Views:
    93
    robert2b
    Nov 28, 2007
  7. goofy11

    Dynamic charts without Named Ranges?

    goofy11, Dec 18, 2007, in forum: Excel Charting
    Replies:
    5
    Views:
    169
    Jon Peltier
    Dec 20, 2007
  8. TSW632
    Replies:
    1
    Views:
    304
    Steve=True
    Mar 3, 2012
Loading...