Excel pivottable with OLAP cubes saves names, not keys
Is there a way to let the Excel XP pivottables/OLAP cubes
reports save the member keys, not meber names? The members
disapperas in the reports when the names are updated i the
dim-table, and this is a problem.
All my Analysis Services dimension levels got keys unique
and names not unique. I can't set the dim-property keys
unique, because they are not.
This is the report info (from Frontpage/OWC, cant find it
A...Excel Maximized Larger than Screen?
I was on a PC yesterday where Excel Maximized was larger
than the PC Screen ... very annoying ... What is the setup
required to set Excel Maximized to PC Screen Size ... As
always ... My many Thanks to those of you that support
this board ... Kha ...
Do you mean excel or a workbook within excel?
If you meant excel, then I'm gonna guess (and it's just a guess) that either
windows got confused (or you changed the display properties for your windows
setting 1024x768 type of thing).
I'd resize it and see if that fixed the problem. If it did, I'd chalk it up to
one time thin...how to set the worksheet direction in Excel XP
in a right-to-left interface the vertical side showing the row numbers of the
excel worksheet appears on the right side of the sheet. how do I change it'
to appear on the left side?
does tools / options / international - default direction ... help?
"inbal" <firstname.lastname@example.org> wrote in message
> in a right-to-left interface the vertical side showing the row numbers of
> excel worksheet appears on the right side of the sheet. how do I change
> to a...How to export policies to excel
Our organization has an in-house security tool that generates a text file
with lists of policies and violations. A VB script reads that text file and
populates certain cells on an excel file. There is one column for each db and
one row for each policy. All are SQL 2000 and 2005 version.
New policies are not covered by the tool. So it needs to be tool+manual
scrips, or PBM, maybe?
I wonder if it can be done through Policy Based Management. I am not sure
how easy to generate a similar excel file out of SQL Server policies. Has
anyone used Powershell and/or Report...Excel, how do I change the column headings from letters to number
I have a spreadsheet that has numbered columns as opposed to the standard
letters. How can I change this back to letters?
Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"lazybee" <email@example.com> wrote in message
>I have a spreadsheet that has numbered columns as opposed to the
> letters. How can I change this ...Naming charts on own sheet
I have a series of charts (which are all contained on their own sheets).
I need to name each of the charts (as they will be used by someone else in a
I have tried clicking on them and also pressing shift before clicking on
them, and I am not able to change the name in the name combo box.
Can anyone advise me of how I can change the names.
Thanks for your help.
If you have chart sheets you can change the name by simply changing the
sheet tab name.
What you described is the method used on chartobjects, which are usually on
Andy Pope, Mi...Excel moving horizontal columns to vertical
I am trying to find a simple way of moving data in horizontal columns
(referencing the key in column 1) to vertical colums (still referenceing the
same key). This would mean automatically repeating the values in column one
for every entry in the moved columns.
I can do this through the pivot table, but this is a long drawn out process.
I'm not sure if this will work for you, but you can try this:
- Highlight & copy on the horizontal value you want to make vertical
- Now highlight the vertical area you want these value to got
- Right Click when highlighted & choose...How do I convert a word table into an excel document?
I have managed to get the info accross no problem but the formatting is all
over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
despite me going into format cells custom then enter mm/yy which has always
You can't use it like that regardless of formatting, you need to put in the
whole date or else Excel will always assume the current year so any real
date used for calculations needs to be numeric and needs a day, so you can
enter (assuming US date format) 07/01/10 and use a custom format of mm/yy
or if you don't need it for...How do I export Lotus Approach files into an Excel spreadsheet?
I need to export data from Lotus Approach to Excel; please help. I am using
an old version of Lotus SmartSuite 9.5 and I have Microsoft Office 2003 Basic.
Well, I don't know Approach at all but is there a common file format that
both use e.g. comma delimited. If so , save in that format from Approach and
import into Excel.
> I need to export data from Lotus Approach to Excel; please help. I am using
> an old version of Lotus SmartSuite 9.5 and I have Microsoft Office 2003 Basic.
...loan amortisatio chart not updating
I use MS Monet 2007 premium. I have created a loan amortisation account
which breaks up my monthly instslment into pricipal and interest. The loan
commencd from 7 October 2005 and is for a period of 5 years. The problem is
that the loan account does ot show any loan instalments beyond 7 October
2006 (exactly 1 year after the commencement). Why is this happening. Why
is the account not updating with instalments which have been debited to my
account after 7 October 2007.
Were you depending on downloaded transaction data for this account? Did the
download link br...Excel sheet not visible
When I open a local copy all I can see is the content of 1 cell in the menu
bar, the work area is all blank gray. I can see the complete sheet (3 Pages)
in print preview. Most users have no problem with this sheet. I have repaired
the installation of Office 2000 and ran all updates, Same problem. It is
something on the local PC that is causing this effect. Other sheets show up
just fine. This is a very simple spred sheet with no formulas.
Maybe it's just off the screen.
(and then resize it the way you want)
New group user 944 wrote:
> When I open a l...Copy constructor
I have a class C1 which contains a member variable of class C2.
C2 didn't have a copy constructor up to now but due to a
change needed (and got) one, and an assignment operator
as well. Now when compiling, I get en error C2558:
"class C1: No copy constructor available or copy constructor
has been declared 'explicit'". It is correct that C1 doesn't
have a copy constructor but I thought that the default copy
constructor just calls the assignment operators of the
members. Since C2 has an explicitly programmed
assignment operator - where is the mi...copy does not work in word 2003
I can't seem to copy from word 2003. I select text but it won't take it. I
can copy from an e-mail and paste into word, but word doesn't seem to want to
copy, either from one word document to another or into my e-mail. It's been
working fine for almost four years, it just acted up. Any suggestions?
The usual reason is some third party add-in that is messing with the Office
clipboard. If you start Word in Safe Mode, can you copy/paste normally then?
From Start | Run (Winkey+R), type in
and press Enter. Word will start in Safe Mode. Open two doc...How do I make a chart with several times during a day
This seems like it may be a simple thing, yet I can not for the life of
me figure out how to do this (or at least semi-easily with VBing it for
I have a simple table filled with the following information (example
12pm 5pm 10pm
11/20 5 4 7
11/21 5 4 7
11/23 5 4 7
11/24 5 4 7
11/25 5 4 7
So basically I am keeping track of a numeric value three times a day. I
would like to make a chart of it with...Catch all outgoing email on Exchange and send copy to specified account
I have been asked to find out if there is anyway to configure our mail
server to catch all outgoing email from certain email accounts on our
Exchange 2003 Enterprise server and forward a copy of this email to a
specified account, also on the Exchange server.
If anyone could point me in the right direction I'd be grateful.
On 25 Oct 2006 04:10:54 -0700, firstname.lastname@example.org wrote:
>I have been asked to find out if there is anyway to configure our mail
>server to catch all outgoing email from certain email accounts on our
>Exchange 2003 Enterpr...Trouble doing a formula for excel
I have a spreadsheet with the following
I would like to add 1 too the number to make unsorder00040.csv and so
I have try mid,right,left i can't seem to do it
"Jason" <Jason@discussions.microsoft.com> wrote in message
> Hi All
> I have a spreadsheet with the following
> A1: z:\data/pc32/tsheets\unsorder00039.csv
> I would like to add 1 too the number to make unsorder00040.csv and so
> I have try mid,right,left i can't see...How can I sort duplicate text data in excel?
I have a large list of noames that I need to make sure that none of them are
duplicated. Is there a way to have excel check it quisker than me reading
every name until I find a duplicate?
After selecting your data go to filter Advanced filter and check "Unique
You can even copy it to another area all uniques entries if you want to ...
"TinaScheu" <TinaScheu@discussions.microsoft.com> wrote in message
>I have a large list of noames that I need to make sure that none of them
>...Excel 2000 vs. Excel 2002
I am having troubles with a workbook that I created that is havin
I created it in 2002, and it opens fine in Excel 2002 for other people
However, when I send it to someone who has Excel 2000, it takes over a
hour to open.
Now I also made a very similar report that works just fine whe
trasferred to excel 2000.
Here are a couple of stats on the workbook that is having problems:
500+ externel links
200+ simple calculations (a1+b1; a1/b1;etc..)
1 Worksheet in the book.
2 columns with conditional formatting
Message posted from http://ww...EXCEL caused an IPF in module OLEAUT32.DLL
I'm using Microsoft Office 2000 Professional on Win98-SE, I suddenly
began getting the error message:
EXCEL caused an invalid page fault in
module OLEAUT32.DLL at 0187:653aac21.
EAX=000047e9 CS=0187 EIP=653aac21 EFLGS=00010282
EBX=0040fd9c SS=018f ESP=0062b54c EBP=0062b5bc
ECX=65350218 DS=018f ESI=00000000 FS=0f57
EDX=00000000 ES=018f EDI=00000001 GS=0000
I tried re-installing EXCEL but that didn't work. I changed the
Oleaut32.dll with an older version and that also didn't work. I ran
Office Setup and chose to run EXCEL from the CD and it went smooth
without problems. ...Adding a certain text label in a excel chart
I am plotting in regularly basis a certain set of data in excel.
Based on some data analysis this set of data has to be fitted to these
y = 1/x^a (1) and /or
y = b/x^c (2)
from data analysis, constants a, b and c are found and are placed lets say
in cells A1, B1, C1.
On my graph, I am putting then two small text labels where the real equation
is displayed: smth. like: y = 1/ x^3.45 and / or y = 0.256 / x^3.12 The
whole process is similar with excel curve fitting, when the “show equation on
chart” is checked.
Thank you in advance
My question is: Can ...survival chart
Does anybody have an idea how it would be possible to
trick Excel into making a survival plot? That is a stepped
graph ploting cumulative survival on the y axis and time
slots on the x.
Any suggestion would be most appreciated.
I don't have a 'survival plot' per se, but you could look for ideas on
my web site. The cumulative probability plot sounds like a possible
If it doesn't give you any idea, post back with some typical data, and
we'll have a look.
- Jo...copying formulas in vba
I was wondering if someone could help me. I am writing a vba script that
takes in data, analyzes it, and then copies the results to a new file. I am
having a problem with two things.
1) I am using a template for the new file so there are a lot of formulas
(sums and std) already defined and ready to use. However, there are some
instances where there is a random amount of additional data I have to put in.
So, I have to apply the same formulas to this new data. How do I copy
formulas from one cell to another (allowing for a change in row) in vba?
Lets say cell(1,4) has the form...Chart "Benchmark" Line Graph Question
I am generating a graph of many team's monthly audit productivity percentages
(bar graph) with a "benchmark" (line graph) at 95% (y axis) across 6 month
period (x axis).
The problem is that the line graph appears on the graph but the ends of the
line are centered in the end columns (left & right). Is there as simple way
to extend the benchmark line out to the edges of the graph?
Have a great day and live life with passion!
...Excel formula #24
What is the formula that brings back a zero for an empty cell instead of
0 0 #DIV/0!
"Dave" <Dave@discussions.microsoft.com> wrote in message
> What is the formula that brings back a zero for an empty cell instead of
> 0 0 #DIV/0!
...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...