LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Deleting cell borders before file opening error occurs?

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
 
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
"Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 James Excel Discussion (Misc queries) 0 November 3rd 09 02:14 AM
format cell when a formula error occurs NDBC Excel Discussion (Misc queries) 5 August 18th 09 08:00 AM
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. Tim Marsden Charts and Charting in Excel 2 October 15th 05 02:10 PM
Error:Invalid File format,while opening an Excel Template file Saurabh Excel Programming 1 January 17th 05 07:15 AM
After deleting a macro, I still get the pop-up when opening file Anne Excel Worksheet Functions 2 December 8th 04 05:31 PM


All times are GMT +1. The time now is 04:50 AM.

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

About Us

"It's about Microsoft Excel"