When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm
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.
Josh wrote:
I think it may be a formula I accidently put in there somewhere. Sometimes
when I cut and paste from one column into another, a message pops up and says
"your formula contains an invalid external reference to a worksheet. Verify
path, workbook and range name or cell reference are correct and try again". I
do have formulas on the other sheets of the workbook, but there shouldnt be
any on this sheet and I can't find any sign of a formula on this page. I did
a control f search within the sheet, and it didn't find anything. I tried
copying the data into a new workbook, but it was still a ridiculously huge
file. Thenks for your earlier atempt, do you have any other suggestions?
Thanks again, --
Josh
"Dave Peterson" wrote:
I think I would open that huge file and just copy all the cells in each
worksheet to a new worksheet in a new workbook.
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.
Josh wrote:
i have an excel file that is 171 MB, I don't understand why... I removed the
autoformatting I thought might have been the problem, but it's still the same
size. It also takes an extremely long time to save my progress, to open or
close, and it sometimes pauses every ten or so rows when I'm scrolling to set
the print area. It shouldn't be that big- There are 5 sheets, each is between
400 and 500 rows, and there's only ten columns. What's going on? Thanks for
any help.
--
Josh
--
Dave Peterson
--
Dave Peterson