Solved

Excel spreadsheets coming up with weird colors randomly.

Posted on 2007-04-09
13
627 Views
Last Modified: 2012-08-14
I have a user that has windows XP SP2,running office 2k3.  She is having an issue randomly where the excel page will open with the colors being off.  Some parts will have weird colors like green.  She can open this document again and then everything will be fine.
0
Comment
Question by:rubu2
  • 4
  • 3
  • 3
  • +1
13 Comments
 
LVL 32

Expert Comment

by:and235100
ID: 18878845
Does she get a prompt to allow/disable macros when opening the document?

If so - is she clicking "Allow macros"?
0
 
LVL 32

Expert Comment

by:and235100
ID: 18878860
Is this only happening on one install/one user?

If so - get her to log out - and delete the user's Application Data folder on the roaming profile (if you are using those - e.g. on a domain) and also on the local workstation.

C:\Documents and Settings\<user name>\Application Data\Microsoft
0
 
LVL 32

Expert Comment

by:and235100
ID: 18878864
If that doesn't help - try running Detect and Repair from any Office spp, Help menu, Detect and Repair...
0
 
LVL 10

Accepted Solution

by:
xanius earned 125 total points
ID: 18878959
Some Workbooks tend to completely (redefine the color scheme of excel E.g. some reporting tools for SAP Data are known to do this). If this is the case, and she needs the macros of those applications, install the following macro on her computer:

Sub ResetStandardColors()
   
    ActiveWorkbook.colors = Array(0, 16777215, 255, 65280, 16711680, 65535, 16711935, 16776960, 128, 32768, 8388608, 32896, 8388736, 8421376, 12632256, 8421504, 16751001, 6697881, 13434879, 16777164, 6684774, 8421631, 13395456, 16764108, 8388608, 16711935, 65535, 16776960, 8388736, 128, 8421376, 16711680, 16763904, 16777164, 13434828, 10092543, 16764057, 13408767, 16751052, 10079487, 16737843, 13421619, 52377, 52479, 39423, 26367, 10053222, 9868950, 6697728, 6723891, 13056, 13107, 13209, 6697881, 10040115, 3355443)

End Sub

' The Array( ...) mus be one line or use the continuation string ' _' at the end of each line

Cheers
Xanius
0
 
LVL 45

Expert Comment

by:patrickab
ID: 18880964
Xanius,

Just for my education - does that array define the standard colour palette? & if it does where did you get it from?

Patrick
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 10

Expert Comment

by:xanius
ID: 18881469
Patrick,

Yes, it is the default colour palette. I read it out of excel itself:


Sub ListColors()
    Dim c
    For Each c In ActiveWorkbook.Colors
        Debug.Print c & ", ",
    Next
    Debug.Print
End Sub

Cheers
Xanius
0
 
LVL 45

Assisted Solution

by:patrickab
patrickab earned 125 total points
ID: 18881515
Xanius - That's cool, thanks.  - Patrick

p.s. Wish I'd thought of that!
0
 
LVL 45

Expert Comment

by:patrickab
ID: 18900608
Xanius,

I've been thinking about this and there is a much simpler way. It's this:

Sub resetpalettecolours()
    ActiveWorkbook.ResetColors
End Sub

Patrick
0
 
LVL 10

Expert Comment

by:xanius
ID: 18900656
Patrick,

generally you're right. In the normal case .ResetColors woks. But I've had bunch of spreadsheets coming form our controlling which screwed up my excel in such a way (Don't ask me how), that I had to do it the hard way. So I wrote the macro and put it in my PERSONAL.XLS and linked it to a Button on a taskbar.

Cheers Xanius

0
 
LVL 45

Expert Comment

by:patrickab
ID: 18900964
rubu2 - Please excuse our asides...

Xanius,

That's intriguing. By the way I have tried using personal.xls and I find it a total pain. I think I must be doing something wrong as I have given it up altogether and deleted it from my machine.

Patrick
0
 

Expert Comment

by:philljo
ID: 22814687
Did you manage to find an answer to this?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now