Help with this SLOW worksheet

[Frank Zavala]

Hello :
Before copy ( manually ) or erase my file I would like to know what kind of solution I have.
I am runnin Excel from Office 2007. I have an existing workbook with about 13 worksheets named everyone. Some of them are linked but not all.
This Workbook is all my work information. Have SALES, PURCHASES, INVENTORY, ETC......
Just 3 weeks ago started with some problems in one specific WORKSHEET ( PURCHASES ).
When I double-click on the shortcut to start Excel and load that workbook, Excel
starts right up, but the workbook takes several SECONDS before it appears. ONCE done it, I test every worksheet and the only problem is one named PURCHASES. It takes several minutes if I want to copy, save, page up or page down. I tried to copy and send it to other File and Excel just freezed and never get back........ I tried copy other worksheets and I could do it........ The only problem is only one WORKSHEET.
If i open a NEW workbook, everything is fine .... works perfectly .........
I scanned my PC twice looking any virus but nothing was found. This file is very important to me so all I want is just last advices.
Do you think PURCHASES WORKSHEET is infected?.......Why is so slow? Why can access faster as before?
Is ther eany way or tool that can revise my file and fix it or what you think?

Hope you can help ......
Thanks,
Frank

 

[Guest]

First of all, it's probably not infected, not if you've scanned the system a
couple of times with no problems found, plus it is just the one sheet
apparently giving you problems, not the entire workbook. There are also some
on-line scanning services you could use to check even more:
http://housecall.trendmicro.com/ is just one of many, and
http://www.kaspersky.com/scanforvirus will even let you scan a single file.
Search for "on line antivirus" and you will find several hits to other
reputable sources (Panda, Symantec and others). And the folks over at
http://wiki.castlecops.com/Online_antivirus_scans have compiled a list of
several available that actually 'do something' other than trying to thin your
wallet out.

Now back to that file: first, since you say that it has all of your work in
it, you want to routinely make backups of that file, even in its current
state of affairs.

Examine and think about what is going on within that sheet - is it much
larger than the others? Does it have any graphics or charts on it? Does it
get its information with links to other sheets or other workbooks or from
queries to other data sources?

The simplest thing may be to rebuild the PURCHASES worksheet within the
workbook, start from scratch with a new sheet and just create a new one that
has all of the same formulas and gets any linked information from the same
locations. You'll then have to check and see if any other sheets in the
workbook get information from it and point those to the new sheet. Once
that's done, delete the old, troublesome PURCHASES worksheet and see how it
acts.