http://www.labnol.org/forums/tags/excel Help Center Tag: excel - Recent Posts en-US Sun, 22 Nov 2009 03:14:24 +0000 http://bbpress.org/?v=1.0.1 q http://www.labnol.org/forums/search.php http://www.labnol.org/forums/topic/excel-2007-repair#post-4652 Thu, 12 Feb 2009 16:52:49 +0000 simon.barett 4652@http://www.labnol.org/forums/ <p>If you want your intact data you need to repair your corrupted or recover your deleted excel file then you need excel recovery software for this purpose. When I got this error: This excel file is not in a recognizable format, I tried Stellar Phoenix Excel Recovery Software to repair my excel files. You can try this software for your problem. Try the demo version first from here: <a href="http://www.repair-excel-file.com/" rel="nofollow">http://www.repair-excel-file.com/</a> and scan your excel files, if you are able to view your excel files as they were earlier then you need to opt for full version to save your excel files. </p> http://www.labnol.org/forums/topic/excel-2007-repair#post-3564 Mon, 06 Oct 2008 14:49:00 +0000 raghavendra9916 3564@http://www.labnol.org/forums/ <p>I heard about not bad application-how to fix Excel errors, will help you to repair Excel file error message: Excel error the file is not in a recognizable format. </p> http://www.labnol.org/forums/topic/excel-2007-repair#post-3558 Sun, 05 Oct 2008 16:38:05 +0000 zlatan24 3558@http://www.labnol.org/forums/ <p>I heard about not bad application-<a href="http://www.recoverytoolbox.com/excel_error.html" rel="nofollow">how to fix Excel errors</a>, will help you to repair Excel file error message: Excel error the file is not in a recognizable format. </p> http://www.labnol.org/forums/topic/excel-2007-repair#post-3395 Thu, 18 Sep 2008 16:13:17 +0000 sivaram.ch 3395@http://www.labnol.org/forums/ <p>What happens if you opt to NOT Repair ? What version does your software program export its data in?</p> <p>Also what kind of XLS workbook is it? Are there any macros or any sort of scripts/objects embedded in the workbook?</p> <p>If you have a Google account, try uploading the file to Google Docs to see if there are any errors while importing said file. And lastly, if you could upload and link a sample file which *doesn't* work in your 2007 installation here in this forum, perhaps we could take a closer look at it. </p> http://www.labnol.org/forums/topic/excel-2007-repair#post-3388 Thu, 18 Sep 2008 01:50:40 +0000 ApplyForAcardToday 3388@http://www.labnol.org/forums/ <p>I have a software program that exports data in .xls format. I've been opening the exported data in Excel with no problems. I upgraded to Office 2007, and now Excel 2007 wants to repair the worksheet. In the process, it deletes almost all of my data. Any ideas on how to have Excel 2007 open the files and keep the data intact?</p> <p>Greg </p> http://www.labnol.org/forums/topic/word-to-excel#post-3172 Mon, 01 Sep 2008 08:15:41 +0000 Philimon 3172@http://www.labnol.org/forums/ <p><a href="http://www.power-battery.com.au" rel="nofollow"><a href="http://www.power-battery.com.au" rel="nofollow">http://www.power-battery.com.au</a> </a> </p> http://www.labnol.org/forums/topic/word-to-excel#post-463 Fri, 31 Aug 2007 15:48:33 +0000 obrads 463@http://www.labnol.org/forums/ <p>Excellent Ram, this works perfectly. </p> http://www.labnol.org/forums/topic/word-to-excel#post-462 Fri, 31 Aug 2007 11:40:15 +0000 ukgali 462@http://www.labnol.org/forums/ <p>OK. The picture is now clear. Since your data source is from WORD, you would not get the TRANSPOSE option. We can bypass it this way:</p> <p>1. Copy data from WORD<br /> 2. PASTE SPECIAL as TEXT in EXCEL<br /> 3. Now that you have your data in EXCEL, again copy this data. This time not from WORD but from EXCEL<br /> 4. Now try PASTE SPECIAL in a different row. You should be able to see the TRANSPOSE option :) </p> http://www.labnol.org/forums/topic/word-to-excel#post-441 Wed, 29 Aug 2007 15:31:57 +0000 obrads 441@http://www.labnol.org/forums/ <p>When I check Paste Special, I dont get a TRANSPOSE<br /> option. I get Picture, HTML, Unicode Text, Text and Hyperlink. I use Excel 2000. </p> http://www.labnol.org/forums/topic/word-to-excel#post-438 Wed, 29 Aug 2007 13:38:48 +0000 mahendra 438@http://www.labnol.org/forums/ <p>nice one Ram!! </p> http://www.labnol.org/forums/topic/word-to-excel#post-436 Wed, 29 Aug 2007 11:22:09 +0000 Anurag 436@http://www.labnol.org/forums/ <p>Perfect Ram - Transpose is the way to go. </p> http://www.labnol.org/forums/topic/word-to-excel#post-435 Wed, 29 Aug 2007 11:03:32 +0000 ukgali 435@http://www.labnol.org/forums/ <p>Even simpler.</p> <p>Copt data from WORD. Right click in EXCEL &gt; PASTE SPECIAL &gt; check the TRANSPOSE option. </p> http://www.labnol.org/forums/topic/word-to-excel#post-432 Wed, 29 Aug 2007 03:01:48 +0000 obrads 432@http://www.labnol.org/forums/ <p>Thanks, the way you explained it works quite<br /> well with columns. However I should have said I needed the data in ROWS instead of columns. The info is given to me like this:</p> <p>company<br /> address<br /> city<br /> state<br /> zip code</p> <p>but I need to put it into excel this way:<br /> Company Address City State Zipcode</p> <p>sorry for not clarifying this earlier.<br /> Monica </p> http://www.labnol.org/forums/topic/word-to-excel#post-430 Tue, 28 Aug 2007 22:25:20 +0000 mahendra 430@http://www.labnol.org/forums/ <p>Just copy paste the table...</p> <p>It will work for sure</p> <p>cheers </p> http://www.labnol.org/forums/topic/word-to-excel#post-428 Tue, 28 Aug 2007 20:55:16 +0000 Anurag 428@http://www.labnol.org/forums/ <p>Copy the entire table in Word and paste that in Excel.</p> <p>Excel is smart enough to recognize tabular entries and auto-converts them into columns.</p> <p>If that doesn't work, attach some sample data here. </p> http://www.labnol.org/forums/topic/word-to-excel#post-421 Tue, 28 Aug 2007 11:46:30 +0000 ukgali 421@http://www.labnol.org/forums/ <p>There is absolutely no need to get any SW. Simply copy the entire table from WORD and right click in EXCEL to PASTE SPECIAL. PASTE SPECIAL gives you many options to paste the content as. You can choose 'TEXT' if you simply need to retain the excel default format. Else you can choose from various other options like HTML etc. </p> http://www.labnol.org/forums/topic/word-to-excel#post-419 Tue, 28 Aug 2007 01:58:08 +0000 obrads 419@http://www.labnol.org/forums/ <p>Hi, if I have 300 entries with 8 columns (like what I have below) in Word, how can I convert it to excel without typing each entry. Is there a software I can download to do this?</p> <p>company<br /> address<br /> city<br /> state<br /> zip code<br /> contact person<br /> phone#<br /> email</p> <p>many thanks<br /> Monica </p>