| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting cell borders before file opening error occurs?
And plain vanilla is very nice!
timlow wrote: Dave, My IT department wouldn't allow downloading Open Office. But, I opened the file in Office 2003 and it repaired it automatically. It made it a mess because it erased ALL the formatting and macros, but all the important data was there. This saved dozens of manhours!! Thanks. Tim "Dave Peterson" wrote: A few people have posted that they could open the file in OpenOffice, then remove some of the formatting, save it and then excel would open that file ok. http://www.openoffice.org, a 60-65 meg download or a CD timlow wrote: I have a large Excel 2000 workbook that won't open because it has "Too many different cell formats." My solution is to somehow get in and delete all the borders on the one non-hidden worksheet to try to get rid of a few hundred cell formats. Is it possible to stop the error message and delete the borders or cell shading before the error occurs? I have already gone to a website that supposedly sells software that will do this for 100 british pounds. There has got to be an easier way. Thanks in advance, Tim -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 | Excel Discussion (Misc queries) | |||
| format cell when a formula error occurs | Excel Discussion (Misc queries) | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
| Error:Invalid File format,while opening an Excel Template file | Excel Programming | |||
| After deleting a macro, I still get the pop-up when opening file | Excel Worksheet Functions | |||
Threaded Mode
