Excel crashing on Save! Help!

R

Raysoc

Board Regular
Joined
Feb 10, 2009
Messages
227
I have an .xlsm file that I saved last night at 4:30pm today any time i try to save the file it auto crashes.

I cant save it on the network or locally, I can't save it as a dif file type it all causes the crash.

Other files are fine its just this one.

I have tried moving all sheets to a dif file still crashes..

Any ideas?? I will lose days of work if I can't get this file to work!
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Try copying the spreadsheet into another spreadsheet and rename the file and extention to a flashdrive.
 
Upvote 0
Check to see if there are any Workbook_BeforeSave macros stored in the VBA editor
 
Upvote 0
over 15 sheets in this workbook... and all dependant on each other.

One macro in here but it has no before save function. Its just a macro to break all links and needs to be ran.
 
Upvote 0
Sounds like it is a corrupt file. Try what Tinkerton posted in Post#2
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
Excel Crashes when I Save Any File
Replies
4
Views
271
nolass
N
K
  • Question
Excel Crashes after VBA adds rows to table
Replies
6
Views
248
Domenic
D
8
  • Question
VBA Macro Error 76; File Path not found
Replies
5
Views
150
81jamesacct
8
E
  • Question
Trying to open misbehaving XLSM file: eliminating macros as a cause?
Replies
4
Views
759
EdNerd
E
Knockoutpie
  • Solved
VBA Save Personal.XLSB to second file path if first file path is not available
Replies
3
Views
314
rollis13
rollis13

Forum statistics

Threads
1,216,117
Messages
6,128,935
Members
449,480
Latest member
yesitisasport

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top