| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.mac.office.excel,microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.mac.office.excel,microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.mac.office.excel,microsoft.public.excel
|
|||
|
|||
|
Opening file cause rows to lose
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 |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.mac.office.excel,microsoft.public.excel
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL 2007 lose formats when opening file exported from Oracle Discov | Excel Discussion (Misc queries) | |||
| Opening file cause rows to lose | Excel Discussion (Misc queries) | |||
| Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions | |||
| Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions | |||
| Opening CSV file with 69000 + rows in Excel using VBA | Excel Programming | |||
Linear Mode
