ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening file cause rows to lose (https://www.excelbanter.com/excel-discussion-misc-queries/192403-opening-file-cause-rows-lose.html)

happytoday

Opening file cause rows to lose
 
I am trying to open a file of 48215 row written in Excel 2003 but only
12121 appeared from 48215 when I am trying to save as Excel 95 format
because of another application only reads Excel 95 fromat
Thanks

Peo Sjoblom

Opening file cause rows to lose
 
It's because Excel 95 does not have that many rows. You need to split them
up on multiple sheets

--


Regards,


Peo Sjoblom


"happytoday" wrote in message
...
I am trying to open a file of 48215 row written in Excel 2003 but only
12121 appeared from 48215 when I am trying to save as Excel 95 format
because of another application only reads Excel 95 fromat
Thanks




happytoday

Opening file cause rows to lose
 
On Jun 24, 6:44*pm, JLGWhiz wrote:
I believe Excel only allowed about 16,800 rows per sheet in the 95 version. *
When you are saving down from xl2003 you would have to split it up in less
row volume per page to fit the xl95 format.



"happytoday" wrote:
I am trying to open a file of 48215 row written in Excel 2003 but only
12121 appeared from 48215 when I am trying to save as Excel 95 format
because of another application only reads Excel 95 fromat
Thanks- Hide quoted text -


- Show quoted text -


Any smart computerized solution to solve that problem to convert 2003
format file into 95 format file in one single file .


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com