Hidden text in Excel worksheet?
Thread poster: Lagom

Lagom  Identity Verified
United Kingdom
Local time: 00:15
Swedish to English
Apr 19, 2007

I am trying to translate an Excel worksheet with TagEditor (2007) but the text that appears in TagEditor is totally different from the text in the worksheet.

According to the settings for the Excel document there should be no hidden text and I have no idea what is happening or how to correct the problem!

Any suggestions gratefully received!



Alison Schwitzgebel
Local time: 01:15
Member (2002)
German to English
+ ...
Excel has a function to hide sheets Apr 20, 2007

I had this once. I translated an Excel file with supposedly 20 or so sheets (I can't remember the exact number now - but there were loads of them). However the customer (agency) could only see five sheets in the file. THe other 15 had been hidden (Format - Sheet - Hide (rough translation of my German Excel)). The upshot was that they only paid for the 5 sheets.

Take a look in your Excel file and see if there are any hidden sheets.

Also, you can hide individual columns or rows by dragging them closed (using the gray column and row tags).




Lagom  Identity Verified
United Kingdom
Local time: 00:15
Swedish to English
Thanks Apr 20, 2007

Hi Alison,

The settings in Excel were set to display all hidden text and I could not find any hidden worksheets....

In the end I gave up with using TagEditor and used SDLX instead which gave me both the 'hidden' and the visible text from the worksheet that I was attempting to translate.

I am still no wiser to what was happening and could not find any help on the SDL site, the Trados user group or the Excel help files!



To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Hidden text in Excel worksheet?

Advanced search

Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »

  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search