Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.mac.office.excel,microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.mac.office.excel,microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.mac.office.excel,microsoft.public.excel
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do i lose EOMONTH on file close Jake Excel Worksheet Functions 2 May 30th 08 06:00 PM
creating hyperlinks in excel that won't lose integrity when file m Allison Excel Worksheet Functions 3 March 20th 07 02:52 PM
Columns A - BY and 336 rows.Too much to filter&sort?Lose info. greenlawn06 Excel Worksheet Functions 1 May 16th 06 09:40 PM
Columns A - BY and 336 rows.Too much to filter&sort?Lose info. greenlawn06 Excel Worksheet Functions 2 May 16th 06 07:17 PM
I lose cell comments in Excel when moving a file via a USb drive Marvyn Excel Discussion (Misc queries) 0 January 19th 06 05:02 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"