Replies

You most probably need to repair System Restore files or/and other system files, and in this case given your other recent thread, it would be good run the system file checker. It will scan for missing or corrupted system files and repairs them.

Start a Command Prompt as Administrator (right-click the shortcut and select run as Administrator).

Run: sfc /scannow

See: How to use the System File Checker tool to troubleshoot missing or corrupted system files on Windows Vista or on Windows 7

Thanks, I’ll give it a shot. Given that this system spent time in the shop with a Vista update screw up, then the hard dirve croaked, then i got that trojan, I’m not feeling too confident. Morituri te salutamus!

You should be able to remove it using a program called Malwarebytes. For more details see Remove Antivirus System Pro (Uninstall Guide)

Thank you. I saw that and was uncomfortable in what it asked me to do…and the Trojan was not letting me access those files anyway. It looked like a ton of tricky steps. I wasn’t sure how to get started. Luckily, I was able to use ERUNT to restore a cleaned up registry and get going again. My new question: Why didn’t ZA or AVG defend my system? I spend plenty on that stuff and they let me down. Also, was it my status as an Administrator that also contributed to the successful invasion? If I had been a Guest or non Administrative user, would this not have happened? Thanks!

Have you looked on the Add-Ins tab? That’s where all my customized Excel 2003 toolbars ended up.

Snagit is there, nothing else. the xlb file is in the Excel (but not XLSTART) file. Clicked it to open but it still did not appear in the Add-ins. I have others, like the Flexible Find and Replace utilility, CellMath, Hilite Filters, and Calculation add-ins. I wonder where they went.

I may be way off – but its a shot.
Take a look at the attached workbook that uses VLOOKUP formulas.

Looks pretty good. Will test drive. Thanks a lot!

Great, thanks. I’ll give it a try

The pst files are somewhat large. I do archive when that happens. We are on an Exchange server. I have a ton of rules on handling mails from certain parites: I assign them Categories which then are used in my Search folders to sort by topics or people, such as auditors or employment agents. So I’d like these to run reliably. They always had and suddenly stopped working.

Seems to work. Thanks.

Open a “problem” workbook and a worbook with a “normal” color palette.
Activate the problem workbook.
Select Tools | Options…
Activate the Color tab.
Click the dropdown arrow of the “Copy colors from” dropdown list (it’s shown in post #9 higher up in this topic).
Select the workbook that has a correct color palette.

I’m back about this problem. Many folks on my team now have it. Is there a way to write a macro to reset the color palette by using the ColorIndex number and forcing the whole palette in the book to reset that way? I think there are only 56 colors in the ’03 palette. Thanks!

Seems to work great! Thanks much, a real timesaver.

Use

…*((Sheet1!B1:B6000=123)+(Sheet1!B1:B6000=617)+(Sheet1!B1:B6000=552)+(Sheet1!B1:B6000=333))*…

OK! Thanks.

You can try importing the color palette from a workbook that has a normal palette. Both workbooks must be open for this.

Can you give me the steps? I don’t see anything in the menus about such a process. BTW I just had someone send me from their laptop a workbook with a good color pallett. When I opened it up on my laptop….bad palette! Is there any way to test my on-board video for this?

I see the same color fields in both tabs as you show. Amazing. Yet the pallets in the workbooks are missing colors. Is there any macro to reset? Why do you think that reset button doesn’t work? because there’s nothing wrong with the pallet in the options tab? guess so. If I were to “customize” the “bad pallets” in specific workbooks back to defaults, woud that eliminate the color problem? Can I be shown which of those colors I should select in the rebuild? Thanks.

Most of our files are still created in 2003.

Which version of Excel are you using?
When I open your sample workbook in Excel 2002 (XP), it has the default color palette:

That’s incredible. That’s not what I’m seeing a this end. That looks like what it should be, but I do not get that palette. We are currently using 2003 in XP, but are getting 2007 files from other people. Here is an image of what I see everywhere. Any suggestions? Could it be a hardware issue?

Look at the color pallet on this one..same as in my book.xls in startup. The pallet in Options does not seem correct and yet it will not “reset”. When I open up workbooks from others, I get this type of pallet. I know they do not send them wiht this fill color. Thanks.