Solved

excel error

Posted on 2014-02-19
8
346 Views
Last Modified: 2014-03-16
when open a excel it is getting below erro

a dde error occured , and a description of the error cannot be displayed
0
Comment
Question by:techp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 10

Expert Comment

by:Subhashish Laha
ID: 39870093
Filename or File path is too long.

Resolution:

- Rename the file so that it has a shorter name.
- Rename one or more folders that contain the file so that they have shorter names.
- Move the file to a folder that has a shorter path name.

Reference link
http://support.microsoft.com/kb/325573
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39870110
This could be because Excel is trying to open a corrupt file or one which exceeds the 259 character limit for filenames (usually a network or sharepoint based file because the 259 characters include the path)

Does this happen every time you open excel or only with certain files?
If its every time you may have an incorrect file in the XLSTART directory which will depend on your OS and Excel version, this link will help you find it:-
http://www.officetooltips.com/excel/tips/opening_workbooks_automatically.html

There are several other files which could be opened when excel starts - in addition to any that are in the XLSTART directory:- its worth checking if any of these have become corrupted - use windows to search for them:
 *.xlb can hold any personal toolbars you have created
 book.xlt is the default for new workbooks
 sheet.xlt is the default for new worksheets
 personal.xl* contains any personal macros
 *.xlt Any other templates you've saved in XLSTART so will be automatically opened
0
 

Author Comment

by:techp
ID: 39870287
it is opening on desktop .....but not in folder
0
Simple, centralized multimedia control

Watch and learn to see how ATEN provided an easy and effective way for three jointly-owned pubs to control the 60 televisions located across their three venues utilizing the ATEN Control System, Modular Matrix Switch and HDBaseT extenders.

 
LVL 19

Expert Comment

by:regmigrant
ID: 39870304
so if you click on excel and load nothing it's ok but if you are loading a file from within a folder it fails?

Is this on all folders on the local machine or on network folders or both - can you provide an example filename of something that doesn't work?

Do any files work or is it all files opened from within a folder?

Have you recently changed the excel setup at all?
0
 

Author Comment

by:techp
ID: 39870316
some excel files ....

 all in local computer...

 only problem file in folders

 not in desktop
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39870544
Go to add/remove programmes and run a repair on your office installation to see if that helps.

find Xlstart folder on your computer and see if there is anything in there -  move the files to another directory temporarily

restart Excel and if the problem has gone away move the files back one at a time until it breaks and you have identified the problem file

if that doesn't help post an  example file that fails on here and copy the path so we can see if the problem lies there
0
 
LVL 59

Expert Comment

by:LeeTutor
ID: 39932855
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
An article on effective troubleshooting
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question