Pivot Table Cycling Through Page Fields Automatically
Hi. I am trying to cycle through a complete set of data in one of the
parameters in the "Page" field. For example, there are 500 investments, and I
want to compute the internal rate of return (IRR) for each investment based
on a series of cashflows for each investment.
The IRR is a function that is placed outside the pivot table. As each
investment number is chosen, the underlying pivot table cashflow data
changes, allow the IRR function to pick up these cashflows and compute the
IRR. However, if there are 500 investments, this becomes very time consuming
- especially if the...Can I fade the edges of photos that I use?
I am trying to use photos in a publisher document that I want to fade the
edges of, is this possible to do with publisher?
> I am trying to use photos in a publisher document that I want to fade the
> edges of, is this possible to do with publisher?
Not really. You should use dedicated image manipulation software for
this, such as Photoshop Elements, Paint Shop Pro, or Microsoft Digital
Ed Bennett - MVP Microsoft Publisher
Are any of these programs typically come loaded on a computer?? I have
another question - ca...exchange 2003
I just set up a mail server at things are working fine in
the network where it resides. The issue is that I have 5
other buildings that are connected via a VPN, and they
can not connect.
Do I need to change settings at their locations? DNS??
It depends on type of client, but generally proper DNS setup is
required. Also make sure that no firewalls interfere.
> I just set up a mail server at things are working fine in
> the network where it resides. The issue is that I have 5
> other buildings that are connected via a VPN, and they
> can not co...Using different form strings to filter
Hello. Is there a way to code a query to have it use a filter string
if a form is open, or ignore it if the filter is not open?
Query Name: Query1
Form: Form1 and Form2
Query fields: Field1 and Field2
I have a string in field 1 and 2
Forms!Form1!Field1 in the first field of the query, and Forms!Form1!
Field2 in the second field. Can I also have Forms!Form2!Field1 in the
query as well? I have tried this, but a box pops up and asks for the
information from form 2 when it is not open.
> Hello. Is there a way to code a query to...Doing Analysis from large amounts of DATA
I have an attachment that's apart of this message & within it I have 3
tabs 1) Revenue 2) Expenses & 3) Net Position. I would like to do some
Analysis on the above three thou a way where I can manipulate the Data.
How would I go about doing this? I've tried a Pivot Table thou it didn�t
work out in the sense that it was messy & just failed in calculating
stuff, not sure if I did it right thou.. Would really appreciate all
the help as I actually have about 20 of these sheets which from that
fall into 4 groups being 5 sheets per group. I hope this all makes
sense, wo...lost data when opening excel workbooks ; text import wizard popup
When opening many of my excel files ,which all have the same modification
date, I come across the text import wizard which states that my text in these
files is 'delimited'. All of the files ,including a few word doc.s have had
their data changed to show all " y " with two dots above the letter for as
far as the eye can see. No import or export has been done with the files and
no modifications were done on that date, as far as I know.
Is this a corruption problem or is their some 'fix' that I am overlooking.
Thanks for any ideas.
...Saving a calculated field
First, yes I have read the threads on storing a calculated field and that it
is bad mojo to do that. However, I have pay data that I calculate and input
to a database and it must be able to be reconciled with our ADP data. So I
need the ability to change and fix the data so it does not change as a result
of recalculations. I have a form with a field that calculates the pay based
on hours and pay rate. I have another field (the "copy" field) next to that
one that has the control source set to the database field. I have set the
default value of that field to be equal to the...Algrebraic Functions
How would you solve a function with input 1 output 8.
Then input 2 output 14.
next input 3 output is blank
then input is blank Output is 24.
the input is blank and the out put is 28.
Finally, the input is 6 and the output is blank.
It occurred to me that if you assume the input blanks are 4 and 5, then you
could use the Add Trendline option within Excel charts to show you what the
potential functions could be.
Try plotting x: 1, 2, (blank cell), 4, 5 against y: 8, 14, (blank cell), 24,
Use an x-y scatter chart and, when plotted, right click on a data point an...Wrapping text in a cell
In a single cell, suppose I want text to appear on two lines. Viz:
How do I do that so that I specify the wrap point?
If you are typing the data into the cell use Alt-Enter between each
string to indicate where you want a line break to occur.
Case One<Alt-Enter>Case Two
Alt + Enter
Lilliabeth's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27741
View this thread: http://www.excelforum.com/showthread.php?threadid=476428
If you...using beforeprint
I am trying to get an application to append a file on a sheet printout.
I am using Workbook_BeforePrint. It prints fine, but doesn't seem t
execute the sub. What's wrong
Message posted from http://www.ExcelForum.com
you may post your existing code :-)
Also check that you have put this code in your workbook module
> I am trying to get an application to append a file on a sheet
> printout. I am using Workbook_BeforePrint. It prints fine, but
> doesn't seem to execute the sub. What's wrong?...Is it possible to highlight text?
I'd like to highlight just some of the text in a cell - not the entire
Select the cell and in the edit bar you can then select (highlight)
some of the text with the mouse and format how you wish, eg bold,
different colour, different background colour, different font/font size
Hope this helps.
This will NOT work in a formula. Works only if all text.
"Pete_UK" <firstname.lastname@example.org> wrote in message
> Select the cell ...Access, average several fields in one row
I have several rows of data in a field, I need to average all the entries in
I have 12 fields for 12 months of data, I need the average of the sum of all
non blank entries.
For example 3 months completed, the solution in Excel is
I am looking for method to average the sum in Access
One way if you can't change your data is to use a VBA function. I've posted
one below. You would call it in a calculated field in a query. Assuming your
field names are the abbreviated month names the expression might look like the
Field: fRow...Using Ghost as OS Backup
I attended a class a while back where the exchange admins said they used
Ghost to clone the OS drive. I bought the product and it says that during
the clone process it temporarily removes the server from the domain. Has
anyone done this or had any problems?
On Mon, 21 Nov 2005 05:26:28 -0600, "Fred T" <email@example.com> wrote:
>I attended a class a while back where the exchange admins said they used
>Ghost to clone the OS drive. I bought the product and it says that during
>the clone process it temporarily removes the server from the domain. ...DPM sometimes uses too many tapes
Hi, i have problem with DPM long term backups on tape. I have collocation
enabled so that is not a problem. Sometimes DPM uses too many tapes for same
protection group, sometimes it uses 1, and then sometimes 2 - 4. Amount of
data is always same. Can anybody help me please, what could be the problem?
Can you explain protection group configurations as well as tape usage in
detail, so that we can analyze on what is happening?
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tornado" <Torn...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...Do you need Access to use an Access Database for data entry only?
We have an Access database completed. Now we will use it for reading as well
as for data entry. Do we need to install Access for every workstation
needing the database for data entry or reading?
No you don't necessarily need Access on every computer. You CAN use the
Access Runtime and if it is in Access 2007 you can use it for free. If you
are using another version then you would need to purchase the developer's
edition to be able to legally distribute the associated Access runtime.
If you do have 2007 and want to use the runtime, make sure your Full version
of Access doe...is there any way I can trap for the use of navigation buttons?
Is there any way I can trap for the use of navigation buttons, such as
Next, Previous and New record?
Probably. Trap what and when?
"Stapes" <firstname.lastname@example.org> wrote in message
> Is there any way I can trap for the use of navigation buttons, such as
> Next, Previous and New record?
On Wed, 16 Jan 2008 05:14:20 -0800 (PST), Stapes
No. And there shouldn't be a reason for that. There are plenty of
events in...Cannot stop using online services with First Tech Credit Union
My bank, First Tech Credit Union, recently upgraded their online banking
services. This upgrade also included a change to the user name and password
used for online banking in Money 2006.
Their upgrade instructions
(http://www.firsttechcu.com/help/help_guide_money.html) say to disable online
services for your Money file as the third step to upgrading to the new
services. The problem is that when I click on Stop Using Online Services in
Money nothing happens. I click on OK and Money hangs for a bit then comes
back with no change, clicking on OK again has the same effect, clicking on ...Using paste in macro but with variable references.
I am trying to use the paste function in a macro but it needs to be
I have split a list of data (team workloads) into the seperate teams
and by days of the week. I now need the macro to compile one book with
all the data in order.
The headings for each team are already set on a worksheet so the data
needs to be entered under each heading For example:
Team A Day 1 under the heading "Team A Day 1", Team B Day 1 under the
next heading on the same sheet "Team B Day 1".
I hit problems as the workload ammount will alter from week to week. So
of course asking...Using CComboBox embedded in CToolBar
I've derived a class from CToolBar and overridden OnCreate to replace 2
placeholder buttons with 2 combo boxes. The two combo boxes are also
derived from CComboBox, and populate themselves with appropriate strings.
My problem is that I'm not sure of how to inform my application when the
user has selected a new item in one of the combo boxes. I've added a
handler for the CBN_SELCHANGE message to the CComboBox, but I don't know
what to put in it. What is the best way to forward the message to the
Also, when I replace the placeholder buttons, can I reuse their ...need to make a formula that would add a field value to current dat
I have made a form in which I input different values. On of the values is
(How Many Days). Now I need to a assign a default value, or expression (not
sure which way to go about this) that will take the date value for (Date) and
add the value (How Many Days)
I figured that the formula should read =sum([Date]+[How Many Days])
But that is not giving me any results, thanx for your help in advance
=DateDiff("d", Date(), [How Many Days])
"J Man" wrote:
> I have made a form in which I input different values. On of the values is ...Changing Functional Currency #4
Try to change the functional currency to Z-CNY.
ERROR = Activity for this currency already exist.
Finance made 2 GL transactions.
Can we remove the transactions (Tools >> Utilities >> Financial >> Remove
History) or (File >> Maintenance >> Clear Data ) then change the functional
Which tables should I remove history or clear data.
Can someone on the board help us?
Once you process a transaction, you are stuck with the functional currency.
I have not seen a table fix for this problem on the board. Consider creating
a new database an...is there a way of using a second monitor as a customer display
This is a multi-part message in MIME format.
Does anyone know if rms works with 2 monitors. What I mean can you use a
second monitor as customer display or something similar.
A lot of pos systems out there use a second monitor as customer display,
I m not sure if rms supports that option or not but any help would be
Content-Transfer-...Evaluate Yes/No Field Based on User Input
Hi. I have a field that is set to Yes/No. I want to ask the user a question
and based on their response (whether they type yes or no) I want the query to
check the field and return all records marked yes is they type yes and all
other records if they type no. How can I do this?
Also, could I present them with a simple text box (having yes and no
choices) or maybe a check box so they won't have to type anything? If you
help me with the first part, this question is a bonus. I'll be happy with
just the first question answered.
A Yes/No field actually stores -...Creating Charts for Use in Powerpoint
I have a series of charts that I need to create for a Powerpoin
I thought it would be easy to just create the charts/graphs in Exce
and then just cut and paste to the PP-Slides. I'm finding that it isn'
quite that easy.
Here are some of my problems that I hope someone might be able to she
some light on and give me some direction.
1. In Excel how do you control the size of the chart?
- When I create a chart 1 and define the data ranges I get a goo
looking chart then I thouht, why reinvent the wheel so I just copy th
chart to create chart 2 and change the data range, but...