(-2147467259): Connection with server application error:Specified cast is not valid 论题张贴者: Elvina Tran
| Elvina Tran 德国 Local time: 17:34 German德语译成French法语 + ...
Hello, I am working with Trados Freelance 2007, Microsoft Office 2007 and Windows XP. I have a problem with an Excel file. The file was skipped during analysis and it can't be opened with TagEditor. The message I get is (-2147467259): Connection with server application error: Specified cast is not valid. I searched the archives but found nothing useful. Does anyone know a solution? Thank you very much in advance. ... See more Hello, I am working with Trados Freelance 2007, Microsoft Office 2007 and Windows XP. I have a problem with an Excel file. The file was skipped during analysis and it can't be opened with TagEditor. The message I get is (-2147467259): Connection with server application error: Specified cast is not valid. I searched the archives but found nothing useful. Does anyone know a solution? Thank you very much in advance. Best regards, Elvina
[Edited at 2008-08-07 20:34] ▲ Collapse | | | Vito Smolej 德国 Local time: 17:34 正式会员 (自2004) English英语译成Slovenian斯洛文尼亚语 + ... SITE LOCALIZER first reaction ... | Aug 7, 2008 |
must be quite a wild Excel file.... Can you cut it up in pieces? Could be comments, strange kind of formulae etc... | | | Elvina Tran 德国 Local time: 17:34 German德语译成French法语 + ... 主题发起人
Thanks for your answer. Vito Smolej wrote: must be quite a wild Excel file.... Yes, I think that is a good description for this monster... Actually I am still wondering why they used Excel to create flowcharts. Can you cut it up in pieces? Could be comments, strange kind of formulae etc... There are neither comments nor formulae. Cutting it in pieces is not possible except copying each sheet in a separate file. | | | Olaf (X) Local time: 17:34 English英语译成German德语 Most likely the file is corrupted | Aug 8, 2008 |
Try re-saving it in a different format and then back to the original format or create a new spreadsheet and copy each sheet from the original spreadsheet to the new spreadsheet. Olaf | |
|
|
DavidHardy Local time: 16:34 Portuguese葡萄牙语译成English英语
Hi. I also got this text error two days ago when trying to open an Excel file in TagEditor but with the error number 80005. Not sure if this refers to exactly the same problem but just in case... You could possibly have something (a flowchart?) that was produced in another file then linked in to the file you are translating and need the original file. In my case the job was quite a complicated Excel file and had several different sheets. I tried saving just one separately a... See more Hi. I also got this text error two days ago when trying to open an Excel file in TagEditor but with the error number 80005. Not sure if this refers to exactly the same problem but just in case... You could possibly have something (a flowchart?) that was produced in another file then linked in to the file you are translating and need the original file. In my case the job was quite a complicated Excel file and had several different sheets. I tried saving just one separately and then opening it, but I had the same problem. It linked data to an external file that was NOT provided. I am just about to go on holiday so turned the job down as I did not know how tricky finding the solution would be and that would have eaten into the actual translating time (sound familiar??!!). SDL have put the following message as one of its latest articles at http://talisma.sdl.com/display/2/index.aspx?c=&cpc=&cid=&cat=&catURL=&r=0.612489938735962 When opening a Microsoft Excel document in TagEditor, the error message Connection with server application error: Specified cast is not valid is shown. (Error code: 80005). Explanation This error may occur when your Microsoft Excel document contains a text box or a drawing that is an OLE (Object Linking and Embedding) object. There is no fix for the issue yet. The best workaround depends on if the object contains translatable text or not. If the object does not contain text that you have to translate, or if you do not have to translate the text within the text box or drawing, you can either delete it from your source file and paste it back into your translated target file after translation, or protect it in Microsoft Excel using Tools > Protection > Protect sheet. All text on that particular sheet will then be automatically skipped when you open your file in TagEditor. If you really need to translate the text within the text box or drawing, the best workaround for this issue is to copy and paste this text into a new empty file and translate it from there. Afterwards you must recreate the object in your translated Excel file and copy the translated text back in. I did find that I could save the Excel file as a text file, then load it into TagEditor, but it kind of defeated the purpose of having an Excel file TagEditor and holiday mode was kicking in by then.... Good luck!
[Edited at 2008-08-09 13:55]
[Edited at 2008-08-09 14:06]
[Edited at 2008-08-09 19:08] ▲ Collapse | | | Miguel RM Local time: 00:34 Japanese日语译成English英语
I just wanted everyone on here to know that I just tried the above suggestion (deleting all of the material in the floating layer text boxes in the file and it worked. Thank you so much for asking/answering the right question. Miguel | | | Nil Ramos 马耳他 Local time: 17:34 French法语译成Dutch荷兰语 + ... how to delete the objects? | Feb 18, 2010 |
I find myself in the same situation. So i tried to delete all the objects etc. However, i find that is impossible to delete the flowcharts or whatever it is that is possibly causing trouble. Has it got something to do with "layers"? never heard of those in Excel ... OK, found it, never mind.
[Edited at 2010-02-19 13:24 GMT] | | | David Xing 加拿大 Local time: 10:34 Chinese汉语译成English英语 + ... formula causes the error | Oct 26, 2011 |
for my case, it is the formula, which causes the error. So, there is no solution for this. | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » (-2147467259): Connection with server application error:Specified cast is not valid CafeTran Espresso | You've never met a CAT tool this clever!
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Buy now! » |
| Anycount & Translation Office 3000 | Translation Office 3000
Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |