ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data which is over 65536 lines long (https://www.excelbanter.com/excel-discussion-misc-queries/55661-data-over-65536-lines-long.html)

KI

Data which is over 65536 lines long
 
Can anyone help?
I am trying to open a file using Microsoft Excel.
However, when I try to open it, as it contains data which is more than 65536
lines long, it will not open properly showing all the data.
Is there anyway to show all the data?
Is there a way to format the spreadsheets beforehand so when you open the
file, anything over 65536 lines will automatically continue onto the next
sheet?

I would be grateful if anyone can help.

Thank you.

Ron de Bruin

Data which is over 65536 lines long
 
Hi KI

See this kb
http://support.microsoft.com/default...b;en-us;120596


--
Regards Ron de Bruin
http://www.rondebruin.nl


"KI" wrote in message ...
Can anyone help?
I am trying to open a file using Microsoft Excel.
However, when I try to open it, as it contains data which is more than 65536
lines long, it will not open properly showing all the data.
Is there anyway to show all the data?
Is there a way to format the spreadsheets beforehand so when you open the
file, anything over 65536 lines will automatically continue onto the next
sheet?

I would be grateful if anyone can help.

Thank you.





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

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