How to open only certain tabs?
Thread poster: Chris P.

Chris P.
United Kingdom
Local time: 19:34
German to English
Jun 29, 2015

Greetings all!

I have an xlsm file with multiple tabs, only some of which require translation.

Answers on a postcard, please, to ............

The second issue I have is (roughly remembered error message):

Unable to open the file which is not Microsoft Excel format.

Thanks in advance for any and all suggestions.


Direct link Reply with quote
 

Natalie  Identity Verified
Poland
Local time: 20:34
Member (2002)
English to Russian
+ ...

Moderator of this forum
Right-click the tab Jun 29, 2015

and choose "Hide" - repeat this for all tabs that you don't want to translate.



[Edited at 2015-06-29 23:49 GMT]


Direct link Reply with quote
 

Chris P.
United Kingdom
Local time: 19:34
German to English
TOPIC STARTER
Thanks Natalie Jun 29, 2015

for your speedy reply!

I take it that means > Open in Excel and "hide" the unnecessary tabs....


Direct link Reply with quote
 

Natalie  Identity Verified
Poland
Local time: 20:34
Member (2002)
English to Russian
+ ...

Moderator of this forum
Exactly so, Jun 30, 2015

of course, all this should be done in Excel before you start translating.

Direct link Reply with quote
 

Chris P.
United Kingdom
Local time: 19:34
German to English
TOPIC STARTER
Thanks again, Natalie! Jun 30, 2015

I expect I'll need to open another question regarding the difficulties in opening the file in Studio 2014.

Your input was much appreciated.


Direct link Reply with quote
 

Balasubramaniam L.  Identity Verified
India
Local time: 00:04
Member (2006)
English to Hindi
+ ...
You can just load it into Studio 2014 Jun 30, 2015

Chris P. wrote:

I expect I'll need to open another question regarding the difficulties in opening the file in Studio 2014.

Your input was much appreciated.


After hiding the tabs you don't want to translate, you can just load it into Trados Studio and prepare it for translation. The hidden tabs and columns won't be seen when you open the file in Trados for translation. After completing the translation and generating the output in excel format, you could unhide the tabs/columns you hid earlier before submitting the file to the client so that he has the full file.


Direct link Reply with quote
 

NeoAtlas
Spain
Local time: 20:34
English to Spanish
+ ...
It should be fine with Studio 2011 or 2014… Jun 30, 2015

Chris P. wrote:

I have an xlsm file with multiple tabs

roughly remembered error message:

Unable to open the file which is not Microsoft Excel format.



… but not sure about Studio 2009…

You may try to save your XLSM with another name from Excel and check…

Or save it as XLSX or XLS, translate it in Studio, and then copy the sheets to your XLSM.

Note: a XLSM file is just a macro-enabled spread-sheet.

Regards,

... Jesús Prieto ...


Direct link Reply with quote
 


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


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

How to open only certain tabs?

Advanced search







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 »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



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