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

Ask a Question

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.