Solved

excel error

Posted on 2014-02-19
8
326 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
8 Comments
 
LVL 10

Expert Comment

by:Subhashish Laha
Comment Utility
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
Comment Utility
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
Comment Utility
it is opening on desktop .....but not in folder
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 19

Expert Comment

by:regmigrant
Comment Utility
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
Comment Utility
some excel files ....

 all in local computer...

 only problem file in folders

 not in desktop
0
 
LVL 19

Expert Comment

by:regmigrant
Comment Utility
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
Comment Utility
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now