LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 13th 14, 04:22 PM posted to microsoft.public.excel.charting
external usenet poster
First recorded activity by ExcelBanter: Apr 2014
Posts: 1
Default Dynamic charts with named range Windows 8.1


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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Named Range dhstein Excel Discussion (Misc queries) 4 October 11th 09 11:15 PM
Dynamic charts without Named Ranges? goofy11 Charts and Charting in Excel 5 December 20th 07 01:31 PM
Using named ranges in dynamic charts (excel 2007) fruitticher Excel Worksheet Functions 8 September 19th 07 04:56 PM
getting the absolute range address from a dynamic named range junoon Excel Programming 2 March 21st 06 01:29 PM
of Named Ranges, Dynamic Charts and scroll bars... z.entropic Charts and Charting in Excel 2 May 20th 05 07:16 PM

All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017