Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 9,101
Default invalid names were detected in this workbook

Hi Please help me to rectify the problem. I have excel file created in office
2003 when I open the file in 2007 it prompt for an error message "One or more
invalid names were detected in this workbook. Those invalid names have been
changed to #REF " and when the file open the chart is not displayed properly.
the file was open in compatibility mode. I tried also to save it in Excel
2007 but stil the chart is not displayed right. Please advice.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,346
Default invalid names were detected in this workbook

Hi,

You do not need to post twice to the same newsgroup, let alone between
newsgroups.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Joel" wrote:

Hi Please help me to rectify the problem. I have excel file created in office
2003 when I open the file in 2007 it prompt for an error message "One or more
invalid names were detected in this workbook. Those invalid names have been
changed to #REF " and when the file open the chart is not displayed properly.
the file was open in compatibility mode. I tried also to save it in Excel
2007 but stil the chart is not displayed right. Please advice.

  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default invalid names were detected in this workbook

On Thu, 2 Jul 2009 22:05:01 -0700, Shane Devenshire
wrote:


Hi,

You do not need to post twice to the same newsgroup, let alone between
newsgroups.


Nice job of completely ignoring the question.

Despite the great answers you do give when you give them, behavior like
this borders on a troll response.

You do not need to be provoking anyone, and if you are attempting to
instruct, it would have been far better to include it as an addendum to a
proper answer to the query.

Maturity comes with age. Consider this a post in a similar vein as that
which you just made here. Please learn from it.
Reply
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
Invalid define names Noreaster Charts and Charting in Excel 6 October 30th 08 01:48 AM
one or more invalid names were detected in this work sheet Huy Hanoi Excel Discussion (Misc queries) 2 December 14th 07 03:34 PM
Invalid Names Steve Links and Linking in Excel 5 July 28th 06 03:29 PM
how do I find names in a workbook full of names aj Excel Discussion (Misc queries) 1 January 19th 06 09:01 PM
Invalid Range Names Old Music Lover Excel Discussion (Misc queries) 4 July 23rd 05 01:53 AM


All times are GMT +1. The time now is 03:23 AM.

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

About Us

"It's about Microsoft Excel"