Ambiguous name detected: tmp.dde error with Word file Sharepoint 2007

Issue:

Open a word document in Sharepoint, it gives an error ""Ambiguous name detected: tmp.dde"

Resolution:

·         Researched on the above error and found that if we rename norman.dot and reopen the word it will recreate it.

·         Did the same.

·         Close all the word document and rename NORMAL.DOTM

·         You will find that under :

·         C:\Documents and Settings\UserAccount\Application Data\Microsoft\Templates

·         Open a blank word document and close it.

·         Check the location again, you will find that normal.dotm will be created.

·        Open the word document from the Sharepoint site and it works fine

Export to spreadsheet error Sharepoint list

Issue

Whenever you try to export the sharepoint list to spreadsheet you get the following error in IE

WEB 1 _https://[Server]/[Site]/_vti_bin/owssvr.dll?XMLDATA=1&List={35667866-8224-44B2-8124-06F2254BEBB5}&View={35667866-8224-44B2-8124-06F2254BEBB5}&RowLimit=0&RootFolder=%2fD721%2fLists%2fDCR01 (_https://[Server]/[Site]/_vti_bin/owssvr.dll?XMLDATA=1&List={35667866-8224-44B2-8124-06F2254BEBB5}&View={35690566-82E4-44B2-8304-06F2254BEBB5}&RowLimit=0&RootFolder=/[Site]/Lists/DCR01) Selection={35667866-8224-44B2-8124-06F2254BEBB5}-{353450566-82E4-44B2-8304-06F2254BEBB5} EditWebPage= Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False DisableDateRecognition=False DisableRedirections=False SharePointApplication=https://[Server]/[Site]/_vti_bin SharePointListView={35667866-8224-44B2-8124-06F2254BEBB5} SharePointListName={70AF7FCA-529D-4DD5-B018-222E1013C042} RootFolder=/[Site]/Lists/TEST

 Solution (2 ways to Solve this)

1.   Repair Office Version from  your machine -

http://support.microsoft.com/kb/924611

2.   Reset the IE to it original state

From IE - Tools - Internet Options - Advanced Tab - RESET

In the Reset Internet Explorer Settings dialog box, click Reset.

Restart IE and try exporting again.

Let me know if this doesn't help. Thanks

The text entered for lookup isn't an item from the list. Select an item from the list, or enter text that matches one of the listed items. Sharepoint Datasheet Error

Issue

Create a Custom List

Add a Lookup Column

Create a New Item , leave the Lookup column blank.

Once the item is created try to edit the same item in Datasheet view.

Once you try to edit the Column in datasheet view it will throw the following error message

"The text entered for lookup isn't an item from the list. Select an item from the list, or enter text that matches one of the listed items."

Resolution

Install the following Hotfix on Client compute to resolve this issue

http://support.microsoft.com/kb/948952

 

The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document.

After some troubleshooting, I found that the document library was created with multiple nested folders.

When we go to third or fourth level of the folder and try to edit any file with office application, we are getting an error – The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document. However if we try to edit the document uploaded on the root of the document library, we can edit it properly.

You cannot edit the office document once the URL exceeds the character limit 340. You can edit the documents only till URL path length is upto 339 characters. You can open the documents, you can upload documents but you can't edit them by right click on document and click on "edit in Microsoft Word". Even this behavior is same with non-office documents also like text documents.

Workaround:
-The only workaround possible is

- open the file directly from the folder, modify and save it as a new file.

Every time you need to save it as a new file. It wont allow to save in the existing file. Or, Move the file one level up and you will be able to do all the operations like edit,check-in and check-out too