Jump to content
Posted 15 March 2007 - 09:42 AM
Posted 15 March 2007 - 10:37 AM
Posted 15 March 2007 - 11:20 AM
Edited by Baloo, 15 March 2007 - 11:22 AM.
Posted 15 March 2007 - 12:06 PM
Via Excel, click File>Open. Left click that file (the one you can't open). Next to the Open button you will see a drop-down arrow. Select "Open as Copy". If it still wont open, choose "Open and Repair". Let me know what gives.
I have tried opening the file that Excel created by using excel and the new file doesn't open
Edited by HitSquad, 15 March 2007 - 12:07 PM.
Posted 23 March 2007 - 09:02 AM
Posted 23 March 2007 - 09:15 AM
Posted 23 March 2007 - 09:40 AM
Posted 05 April 2007 - 08:41 AM
Posted 06 April 2007 - 08:37 AM
Edited by tos226, 06 April 2007 - 08:37 AM.
Posted 30 May 2007 - 10:41 AM
Posted 31 May 2007 - 04:29 AM
Posted 31 May 2007 - 08:20 AM
Posted 04 June 2007 - 09:17 PM
Interesting idea here. The huger the file, the more invitation for error. I have a feeling, as you (projectfocus) do, that it's not it, still, I thought I'll comment how to prevent oversize worksheets. It's very simple. NEVER apply any formats to the entire range of columns or rows (borders, colours), and be very careful where the data really ends. Ctl-End will tell. Often users, accidentally write something in any old cell, and that something can be SPACE, and unless the sheet is checked for a true end, the spreadsheets suddenly is enormous.
Looked at the file size and it was 2.5mb. I know this does not seem that big but for the data that was in it this is huge. I found the sheet that caused the problem by simply see that the slide bar was really small and making excel think that there was data beyond it limits. I don't know if I am explaining this very well. I copied the data from the corupt sheet to a new sheet and the slide bar was back to normal. Saved the workbook again and it was now 214kb.
Posted 05 June 2007 - 10:07 AM
Posted 05 June 2007 - 12:00 PM
0 members, 0 guests, 0 anonymous users