View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonio Antonio is offline
external usenet poster
 
Posts: 134
Default Rebuilding a corrupted workbook

I have a large and complex worbook file that is starting to give me big
problems. Very slow performance when navigating between cells. Unexplainable
crashes of the VBA code which works great in other files.

I want to build a new workbook by copying all cells formulas, values,
format, VBA code etc.

I can copy every worsheet but I fear that I may copy the bug, I believe I
tried that and the problem persisted.

Other than copying manually the contents of each cell and format (and VBA
code) is there a way to copy the workbook while assuring a non-corrupted file?

Many thanks,

Antonio