Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Please how do do this in vba | Excel Worksheet Functions |