I wouldn't waste too much time trying to fix the old--just create a new one.
This may sound simple, but it might not be. Watch out for formulas, named
ranges, named anything, VBA code, headers/footers, filters, and anything else
you can think of.
But it sure sounds easier than trying to fix that 171MB file.
--
Dave Peterson
and to make working with names easier...
I'd use Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name
Manager to search for any hidden names.
You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
But I don't see how that could make a 171MB file.
--
Dave Peterson
Hope this helps.
Pete
Hope this helps.
Pete
Or I like to change my formulas to text
edit|replace
what: = (equal sign)
with: $$$$$=
replace all
Do the copy|paste and then reverse the process.
Edit|replace
what: $$$$$=
with: =
replace all
--
Dave Peterson
--
shrutikhurana
------------------------------------------------------------------------
shrutikhurana's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29868
View this thread: http://www.excelforum.com/showthread.php?threadid=507396
help pls