Collor pallet changes unwanted after SAP export

In order to analyse data from SAP, I create an Excel export of the data, 
this is a standard SAP functionality. The excel file that it creates has a 
different color palette than the standard Excel pallet. This is not a 
problem. The problem is that when I open an Excel sheet that has been 
exported from SAP, it changes also the color palette of all open Excel 
workbooks, rendering some of them unreadable. Closing Excel and reopening 
solves the problem, until I reopen a SAP-exported Excel workbook...

I tried changing the palette using Options - .. - Colors, but then I'd have 
to change color by color, I can't use the copy button as all open workbooks 
(and also newly opened workbooks) will contain the altered pallette. Does 
anyone have a clue how I can stop this from happening ?

I also looked in the SAP exports for VBA code, didn't find any. Using Excel 
2003 and Windows XP.

Thanks,
Carl 


0
8/11/2008 6:24:58 PM
excel 39879 articles. 2 followers. Follow

2 Replies
486 Views

Similar Articles

[PageSpeed] 37

I think I'd just open the SAP file, do a Tools, Options, Color, Reset and 
save the file.  Then it should have the standard pallet.

-- 
Jim
"Carl Willems" <carl.willems_delete_this_@telenet.be> wrote in message 
news:ju%nk.23392$tc1.12045@newsfe24.ams2...
| In order to analyse data from SAP, I create an Excel export of the data,
| this is a standard SAP functionality. The excel file that it creates has a
| different color palette than the standard Excel pallet. This is not a
| problem. The problem is that when I open an Excel sheet that has been
| exported from SAP, it changes also the color palette of all open Excel
| workbooks, rendering some of them unreadable. Closing Excel and reopening
| solves the problem, until I reopen a SAP-exported Excel workbook...
|
| I tried changing the palette using Options - .. - Colors, but then I'd 
have
| to change color by color, I can't use the copy button as all open 
workbooks
| (and also newly opened workbooks) will contain the altered pallette. Does
| anyone have a clue how I can stop this from happening ?
|
| I also looked in the SAP exports for VBA code, didn't find any. Using 
Excel
| 2003 and Windows XP.
|
| Thanks,
| Carl
|
| 


0
jrrech (1932)
8/12/2008 3:05:31 PM
Carl,

We had the same problem.  The solution I found was making sure that the 
"Borders" toolbar was not enabled (View --> Toolbars and uncheck Borders).  

1) Shutdown all instances of Excel
2) Launch Excel and disabled "Borders" toolbar.
3) Open Spreadsheets

Karl

"Carl Willems" wrote:

> In order to analyse data from SAP, I create an Excel export of the data, 
> this is a standard SAP functionality. The excel file that it creates has a 
> different color palette than the standard Excel pallet. This is not a 
> problem. The problem is that when I open an Excel sheet that has been 
> exported from SAP, it changes also the color palette of all open Excel 
> workbooks, rendering some of them unreadable. Closing Excel and reopening 
> solves the problem, until I reopen a SAP-exported Excel workbook...
> 
> I tried changing the palette using Options - .. - Colors, but then I'd have 
> to change color by color, I can't use the copy button as all open workbooks 
> (and also newly opened workbooks) will contain the altered pallette. Does 
> anyone have a clue how I can stop this from happening ?
> 
> I also looked in the SAP exports for VBA code, didn't find any. Using Excel 
> 2003 and Windows XP.
> 
> Thanks,
> Carl 
> 
> 
> 
0
10/9/2008 4:24:01 PM
Reply:

Similar Artilces:

OWA login changed after installing service pack 2!
we have exchange 20003 running on windows 2003 server. I applied service pack 2 last night, and found out our remote users were unable to login. what has happend is this: where our local domain name was simpson.com, but our email address was homersimpson.com, before the service pack update a remote user would type their usename, and it would put the domain name in front - as in simpson\bart (if bart was username). NOW when they try to login it shows homersimpson.com\bart and will not log them in, and I have to tell them to type simpson\bart to get in. what has changed, and how do I p...

Excel Workbook- Can't open file once any changes are made
Hello everyone- I am running Windows XP with Excel 2002 (verison 10.6501.6626 with SP3 and I just completed developing a fairly large Excel workbook wit numerous worksheets and macros. If I send the file to a handful o other people, they are all able to open the workbook and make change with out getting any problems (They can change the file name itself o make changes to the cells within the workbook). Here's my problem: On my computer I can open the base version of th workbook without getting any error messages. However, if I make an changes (no matter how simple, like changing text...

GST tax rate change
Our new federal government here in Canada has announced a reduction in one of our sales tax rates. My question is should we create a new rate ...or adust the existing rate already set in the system? If we adjust the existing rate...would that affect our historical reporting?? TIA Tami While changing the rate on the existing tax details is the easiest method, creating a new tax detail will provide you a provable audit trail that the correct taxes were charged to the proper sales on the proper days without having to run a calculator on each audited transaction. If you can simply cr...

Ownership does change on Account Notes when reassigned
Hello, When an Account is assigned to another user, the Account Notes dont get assinged to the new owner. Any idea why this may be happening ? Appreicate any leads. thanks -G Check the Account to Note Relationship and see if the cascading on assign is "Cascade All" between Account and Note Frank Lee, Microsoft Dynamics CRM MVP http://www.workopia.com/Links.htm http://microsoft-crm.spaces.live.com "Gustho" wrote: > Hello, > When an Account is assigned to another user, the Account Notes dont get > assinged to the new owner. > Any idea why this may be ...

Changing visualizations
Hello, How can I change the character dimension for all the visualizations (all together) instead of changing each visualization one at the time? thanks, Alessandro ...

Changed a form to have two tab control
Code was writtten on the original form, but form is still named the same, the only thing that has changed is the control for the form changed to tabbed control and then I moved the individual controls to the appropriate tabbed sheets. Having a problem with the cmd buttons exiting to a main form, so I am thinking that I need to change the syntax on the code properites somehow. The main form is called "POCheck", the individual tabs are called "PO Form" and "Checkbook Form". I am not sure how the snytax needs to refer to the tabs? Here is an example: ...

Is there a way to export sales data nightly out of MS Point-Of-Sal
Is there a way to export sales data, nightly, out of MS Point-Of-Sale? Possibly into an excel document or so? -- Greg D. GregD wrote: > Is there a way to export sales data, nightly, out of MS Point-Of-Sale? > Possibly into an excel document or so? yes, with a dts via sql server, or with reporting services, or custom tools.. cod ...

color catagories should not change all in series meetings
Color Categories: This feature is useless when dealing with meetings that are set in series. Say I want to tag a meeting to remind me to schedule a sub meeting and only have it affect the one meeting in the series when changing color instead it changes all in series. It needs to react as if each meeting was set-up as single events and not affect the other meetings in future as I have no assignments because the meeting has not taken place. "Mac" <Mac@discussions.microsoft.com> wrote in message news:3CD1734D-019A-46A4-93D0-00EAD89A8017@microsoft.com... > Co...

unable to access exported address book
I have Windows XP. My address book has been emptied of all emails and I can't access the file containing all of my address book contacts. Please help!!!!! I have two identities in Outlook Express that each have different contacts in the address book. I wanted to export my address book from one identity to the other. I clicked File>Export>Choose program to export to...I chose Text file (Comma Separated Value)>Save exported file as .csv type. I saved it. I switched identities. Went to File>import>other address book>When I got to this part there was a pr...

exporting list
Hallo, I have a little problem i'm trying to solve. I would like to know the way to export a list of all e-mail adresses from mij exchange 5.5 server. somebody told me that there was a way to make a report using crystal reports but i have been trying this also without succes. if anybody kan helpme whith this please let me know. Thanks http://support.microsoft.com/default.aspx?scid=kb;en-us;278154&Product=ech http://support.microsoft.com/default.aspx?scid=kb;en-us;155414&Product=ech Martin Salazar wrote: > Hallo, > I have a little problem i'm trying to solve. > I ...

How to modify principal without changing payment amount
I am having a hard time figuring out how to change the principal payment amount without changing the total payment amount. I am using Money 2005, and have all my loan details set up correctly (to my knowledge). I have recurring payments set up in my bills, and the total amount of the loan payment is $100. The problem is that Money puts $100 toward the principal which is not correct. I dont have a problem modifying the transactions after the fact manually, but I can't seem to even do that. I can double click on the transaction to modify it, but as soon as I modify the principal ...

changing GAL view fields in Outlook
I have Exchange 2003 and Outlook 2003 clients. I want to add and remove some of the default fields when opening the GAL in Outlook > (tools/ Address Book). The default fields are: Name; Business Phone; Title; Company; Alias; E-mail type; E-mail Address. I want to add Home Phone and Mobile phone (fields that are already in AD) to this list and I want to remove the fields: E-mail Type and E- mail Address. I know I can view it if I double click on the person but I want to be able to view all at once instead of wasting time opening each one. TIA .. As far as I know, there's ...

How can I change size of the picture without changing chartobject?
Hi there, I have this code in a userform and get with it a picture in the same size as the chartobject - to small. I want a much larger (fill the screen as much as possible). I can easily solve it by changing size of the chartobject before export to gif, but i dno't want to do that. I want to change the size of the gif during or after importing it by LoadPicture. How? Help = Forever happy /Regards Dim ChartNum As Integer Private Sub UserForm_Initialize() Debug.Print "frmPPT initilize " ChartNum = 1 UpdateChart End Sub Private Sub UpdateChart() Set CurrentChart ...

exporting outlook address book to csv file
Outlook Address Book Help states:" To export your Address Book contacts to other programs You can export your Address Book contacts to other Windows Address Book (.wab) files, as well as to Microsoft Exchange Personal Address Book, or any text (.csv) file. To export your Address Book files to another Windows Address Book: In Address Book, on the File menu, point to Export, and then click Address Book (WAB). Locate and select the Windows Address Book file you want to export to, and then click Open. For all other address book formats: In the Address Book, on the File menu, point to ...

How do you change the font size when printing emails in Entourage?
I want to change the size of the font when printing an email. When I look at the preference options for Entourage, there is an option under font that changes the size and type of font used when printing. No matter what I do, the printout does not change. It seems I cannot change the default size and font. On 2/15/08 10:46 AM, in article ee8d8fe.-1@webcrossing.caR9absDaxw, "Rwresh@officeformac.com" <Rwresh@officeformac.com> wrote: > I want to change the size of the font when printing an email. When I look at > the preference options for Entourage, there is an option unde...

Changing formatting on bar charts
I have a bar chart that shows turn around times for various jobs our group has in process. The chart shows the customer name @ the bottom, # of days up the side then the bars are for all the jobs each customer has. Here are my problems/things I want to change: 1) the spacing for each customer is equal whether they have 1 job or 10, can that be adjusted as needed? 2) My bars are so narrow that you can barely see the color because of the customer spacing issue mentioned above(I assume). How can I change the width of these bars? ...

Exporting Mailbox Attributes to a csv file
My company has Exchange 5.5 Build 2653.23 SP4 running in a 2000 environment. Is there a way to export selected attributes of a user's mailbox to a csv file. I know you can do a directory export, but that export doesn't list the attributes. For example, the attributes I may want to gather are distribution lists, limits, or e-mail addresses. For a group of mailboxes, I may want to find out who has limits on their mailbox size and who doesn't. In order to avoid clicking on the properties of each mailbox, is there a more efficient method to extract attribute info on indi...

How to use VBA to Change Color of a Form
I understand how to modify the color of a TextBox on a form using VBA code such as Forms!form2.text2.BackColor = vbGreen Now I would like to change the color of the entire form. How is this done? Thanks -- Brad "Brad" <Brad@discussions.microsoft.com> wrote in message news:3DA736F8-6ADD-455F-A3B3-2B0597C05152@microsoft.com... >I understand how to modify the color of a TextBox on a form using VBA code > such as > Forms!form2.text2.BackColor = vbGreen > > Now I would like to change the color of the entire form. > > How is this do...

Dragging data without changing cell borders
Does anyone know how to drag data only from one cell to others, without dragging borders, colours, etc. so I don't have to go back and fix up all the borders and colours again? Is there a simple setting which allows dragging of data to be done where only the data is dragged? Colin Gibson Hi Colon, Assuming you have text values and not formulas. Rather than dragging you could copy (ctrl+C) or Cut (Ctrl+X) and then Edit, Paste Special, Values If you have numbers or formulas you would have to paste formula, and format separately. --- HTH, David McRitchie, Microsoft MVP - Exce...

Getting shape instances to update when master's dimensions are changed
I have a shape master that is a rectange with some text inside it. When I edit it to make it longer (to fit more text in it), the instances of the master on the page do not update. Can anyone help me with this please? Many thanks. You might be editing the wrong master. Stencil files have masters, you drag these to your drawing. Visio creates a local master and uses this for your shapes. If you edit a stencil shape, it will not change the local master, or instances of the shape. If you change the local master, it will update the instances. Use drawing explorer to view your local masters. ...

Changing y axis labels
Hi, I have a basic column graph in Excel 2003. The source is a grid of cells with a text label along the top (represented by the x axis on the graph), text labels along the left side (represented by the coloured bars in the graph) and numbers within the grid which are the values (represented by the y axis). I'd like to know if I can change the labels of the y axis to be something like Poor, Good, Excellent (each a range of values) rather than the number values. thanks jc Hi, You can add a dummy series to the chart to plot textual Y axis labels. The new series would be xy-scatter...

How do I change a row to a column?
Copy>Paste Special>Transpose>OK>Esc. Gord Dibben Excel MVP On Fri, 18 Feb 2005 08:43:06 -0800, "Amanda B" <Amanda B@discussions.microsoft.com> wrote: ...

Changing tax rate
Hi there, I posted this before and just need clarification...I am not an accountant...but a systems person Here in Canada whe have a federalsales tax rate change starting July 1 After testing just changing the rate on the Tax Detail....the history stays the same... so this response I received is confusing me??? >While changing the rate on the existing tax details is the easiest method, >creating a new tax detail will provide you a provable audit trail that the >correct taxes were charged to the proper sales on the proper days without >having to run a calculator on each au...

sbs administrator account name changed now sbsbackup stops working
Hello, I while back i posted about how people were trying to hack into my computer, so i changed the administrator bane following the guide from ms. Now my sbs backup will not run, here is the log. I have also run vssadmin list writers and there are no errors reported. 2/3/2010 10:00 PM ------------------------------- Date: 2/3/2010 Time: 10:00 PM User: SYSTEM ------------------------------- Backup Runner started. Launching NTBackup: ntbackup.exe backup "@C:\Program Files\Microsoft Windows Small Business Server\Backup\Small Business Backup Script.bks" /d "...

html table import
Hi Our sales organization came up with the idea of taking a web based financial tool, write a huge Excel sheet around it, and update the data every week. From it, they get all kinds of stats and results for the management. So far so good. I'm in charge of the web application. Now since a few months, when they import, after exactly 139 lines, the formatting changes in excel. Instead of being right aligned, the table cells are suddenly left aligned (starting on column i), the 0.00 in the source is suddenly shown as such where it was 0 in the 138 lines before. Then after a few hundred...