can i carryover data automatically from page to page and how?
I am trying to set up a month-to-month data sheet. Can I set it up so that
the accumulated total from one month carries over to the next?
"JimVT" <JimVT@discussions.microsoft.com> wrote in message
>I am trying to set up a month-to-month data sheet. Can I set it up so that
> the accumulated total from one month carries over to the next?
Of course - at the top of sheet 2 in the required column type in
=Sheet1!(Cell the total is in on sheet 1). if you are uncertain as to how to
...After migrating user from Outlook 2002 to Outlook 2003 emails have disappeared
After migrating a user from Outlook 2002 to Outlook 2003, many of her
emails have disappeared. I remember reading somewhere that this is not
an uncommon side effect of this migration. Can anyone tell me how to
reverse this? Is there a setting somewhere?
KingCronos <email@example.com> wrote:
> After migrating a user from Outlook 2002 to Outlook 2003, many of her
> emails have disappeared. I remember reading somewhere that this is not
> an uncommon side effect of this migration. Can anyone tell me how to
> reverse this? Is there a setting somewhere?
Migrating properly wi...Set exchange 2003 to log bouced emails (to non existent users)?
My exchange server bounces emails sent to a non existent user at my domain.
I would like to log all bounced emails, so that I can create mail forwards
for some of those incorrect emails addresses.
Is it possible to log those incorrect email addresses?
The easiest would be have a copy of non-delivery reports sent to an
account such as yours or firstname.lastname@example.org.
You add this in the Messages tab of the Properties for the SMTP Virtual
server in Exchange System Manager.
Danny F wrote:
> My exchange server bounces emails sent to a non existent user at my doma...Changes to the global template
Recently I had to start a new username because of some corrupted files. I
was able to save my documents.
However, everytime that I quit microsoft office a dialogue box appears and
"Word cannot save changes to the global template because it was opened with
read only access. Do you want to save the changes in a template with a
Initially I tried to save it, because I was afraid that the changes to my
document would not be saved. Now I click save, and the next dialogue box
"Microsoft Visual Basic"
"Run-Time errror "5995"
Word c...Split Forms
Is it at all possible to hide the Data Sheet portion of a split form at run
time in 2007?
The only solution I have found is to play with the SplitFormSize property,
but I am afraid that it does not support different display sizes.
Any suggestions ?
...Excel data disappeared after getting message about compatibility M
I tried to save changes to a spreadsheet, and received the following message:
"Compatibility Report for New Customer List.xls
Run on 4/6/2010 19:52
The following features in this workbook are not supported by earlier
versions of Excel. These features may be lost or degraded when you save this
workbook in an earlier file format.
Minor loss of fidelity
Some cells or styles in this workbook contain formatting that is not
supported by the selected file format. These formats will be converted to the
closest format available."
I clicked OK, because fidelity is not imp...Synchronize data across 2 sheets
Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a
sheet called Previous around 5000 rows records.
Both have 31 columns and identical column headers
On the 2010 sheet there are records that have changed, how do I get the
changed records details onto and overwite the same record on the Previous
Not sure if it would help but each record has a unique reference number.
How do i do this ?
Hope this makes sense
thanks for any help offered
If you know which colums are to be changed I would use vlookup function.
Vlookup(lookup valu...How do I protect my comments from being edited by another user?
I regularly send excel worksheets to a co-worker via e-mail and then she
sends it out to others within the company (sales force). There are occasions
when she will need to revise it and send it back to me. How do I protect my
comments so that they cannot be edited, or can I? I received a worksheet
back today that the comments I had entered were changed. These comments are
my back-up and I do not want them changed.
Can anybody help?
highlight the whole sheet
format cells / protection / uncheck locked
highlight the cells you want protected
format cells / protection / check locked
tool...cell protection to allow GROUP/UNGROUP function
2 asthetic questions for all you advanced Excel Users....
Q1. is it possible to protect a worksheet, but still be able to us
the +GROUP & -UN GROUP buttons ? to expand / contract the viewe
Q2. anyone know how to change the colour of the AUTO FILTER button - i
changes from black to dark blue when activated - i would like to hav
this with more contrast and so it jumps out at you ( and the othe
plebs in the office who keep forgetting)
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages dire...Language change in outlook express
I cannot change th language to english in outlook express by defult it has
please help me how to change in options. i check all my regional settings
shows english(us) execpt in word and express.
nishkrish <email@example.com> wrote:
> I cannot change th language to english in outlook express by defult
> it has French.
Ask in an Outlook Express newsgroup.
Brian Tillman [MVP-Outlook]
Ask in the Outlook Express newsgroups
Outlook Express with IE7
http://www.microsoft.com/co...Querying Excel data without another program
I'm an intermediate user of Excel, but I have lots of experience using
Access. If you can give me clues on how to handle the information below
using only Excel, I'd be grateful!
I have a spreadsheet in Excel 97 in which there's a Worksheet named,
"Datasource" with a column "B" containing repetitive data.
I'd like to create a new worksheet in the same Excel file which shows a
single instance of each item used in Column "B".
If I were writing the query in SQL, I'd say
"SELECT DISTINCT [Column B]
FROM [MySpreadsheet]![Datasource...2007 user levels
I only have a limited knowledge but have previously developed a number of
relational databases using Access that have worked very well.
If user level access has been removed in 2007 how do i stop some users
accessing confidential data, while still allowing them to use other parts of
The data base will run on a simple pier to pier network, with one machine
holding data and Access installed on all machines, so do not have MS Server.
Mike" <Mike@discussions.microsoft.com> wrote in message
news:EA03658D-236C-47BC-9F09-FC91674862D0@microsof...How to total cells in a range with data input
Greetings to all members
I am running Excel 97.
An office colleague presented me with an issue that might be of interest to
any Excel whiz and seasoned programmers. I would certainly appreciate any
pointers in solving it. So here goes.
The set of values includes 33 cells ranging from B4:D14. The data type is
numeric. Data is only input in a few cells.
What would be the function to enter in, say, cell A15 to indicate the total
number of cells in range B4:D14 that have received data input? Or does it
involve some behind the scene VBA programming?
B6 = 9 C9 = 4 D11 ...Insert Data From Multiple Worksheets Into One (With Criteria)
Ok, I have created a sales report list that tracks what customers we are
contacting, how we are contacting them, if they are a new or existing
customer and if we sent a quote, along with some other details. There is a
worksheet the salesmen fills out for each day of the month (its linked to a
calendar) and that all goes into a "dashboard" that shows the breakdown with
graphs. Now what i would like to do is have another worksheet list all the
customers that we sent quotes to so they can mark if the quote was won or
lost , state sales projections and give reasons why won ...change direction of cursor after enter
In excel 2003, how do I change cause the cursor to go the next cell to
the right, rather than to go to the cell below? Thank you!
Tools > Options > Edit > Move selection after Enter > select Right.
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"duke" <firstname.lastname@example.org> wrote in message
> In excel 2003, how do I change cause the cursor to go the next cell to
> the right,...How do I protect one single cell?
I have a spreadsheet where people are going to type in numbers, and
the final cell is a total, which of course I don't want people to
accidentally type over, as it will lose the formula behind it.
So...... I put some "data validation" behind that cell, to say only
allow entries of text length = 50 - a kind of "mock" condition.
Nobody'e ever gonna type in 50 chars. are they?! And sure enough,
typing in (eg) 854221 brings up the error box to stop them, just like
(eg) HHJSYT brings up the error box to stop them. I even unchecked the
ignore blank" box, so that ent...How-To: Last change date on row
When I set up a database I always include a last change date that auto
updates every time any field in the record changes. Does anyone have a
suggestion for how to achieve a similar function in a spreadsheet. i.e.
put the current date/time in a field in the row whenever anything in the
GGG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29220
View this thread: http://www.excelforum.com/showthread.php?threadid=489447
For example, to put the last change date in...Creating a word2000 document with access 2000 data
I have a database in access 2000 it is basically customer info.
address and dates and timesof appointments. I need to place a button
on the formpage that prints a letter using the customer details and
the date & time entered in the database. Anyone have any clues as to
the easiest way to do this.sort of done it using mailmerge but not
what I want. Actually want a word document to pop up that the staff
can just double check and press print. Any help would be appreciated
even just a point in the right direction to a good source of
to see if the following website's offer...Windows 2008
I am an admin in windows 2008 server. However, I am not able to
c:\Users\<user name>\Local Settings\History
Anyone knows how to change the settings so I can access the folder?
"Jack Black" <email@example.com> said this in news item
> I am an admin in windows 2008 server. However, I am not able to
> access the
> c:\Users\<user name>\Local Settings\History
> Anyone knows how to change the settings so I can...joining data points on graph
I am merging two graphs and one has 23 data points, the other has 9. The
category axis will have 23 data points but the 9 points are spread out, i.e.
they may be at points 1, 3, 7, 15 etc of the 23-point scale. At the moment
the graph will only join points that are beside each other; how do I get them
to connect to the points that have spaces between them?
minihana wrote on Fri, 10 Feb 2006 11:29:04 -0800:
m> I am merging two graphs and one has 23 data points, the
m> other has 9. The category axis will have 23 data points but
m> the 9 points are spread out, i.e. they may be...Stop running sum(Over All) when customer change
I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,”MMM-YY”) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it ...Dynamic data label placement for graphs
I've read the article KB179199 on how to create custom
data labels for charts and it's good, however doesn't meet
all my requirements.
Is there a way to have the data labels automatically move
to a desired location relative to the graph?
For instance, I'm using 50 bar graphs per work book and
would like each data label to be just above their
I looked up article 179199 and got this:
BUG: Grid Based on .QPR File Appears Blank in Visual FoxPro 5.0
which probably isn't the one you meant. By above the bar, are they
horizontal bars and you ...How to change labels on a chart from numbers to words?
Can Someone Please help me? I can't figure out how to change the labels on my
chart in excel from numbers to words!
I'm not sure which labels you want to change to words, but maybe Jon
Peltier's charting tutorial will help you:
> Can Someone Please help me? I can't figure out how to change the labels on my
> chart in excel from numbers to words!
Excel FAQ, Tips & Book List
I suspect it's this page:
http://peltiertech.com/...List all users with Send AS rights
I need to find a utility or script that will show all users who have the
Send AS right enabled. I have looked at the script in Microsoft KB Article
912918 and it list all users who have full mailbox rights but do not have
Send AS rights. What I need is to list only the users who do have Send AS
Is there anyhting that will tell me who has Send AS rights?
MCSE, MCP +I MCP
See if this helps.
Auditing Send-as and Receive As rights via script
> Hel...Separating data in a column
the spreadsheet i am working on has 1 column with 2 possible answers, i.e.
yes/no. what i need to do is separate the replies and then total the yes
replies in another cell and also total no replies in a different cell. How do
i do it?
The following COUNTIF function can be used
The sort or data filter command can be used to separate the replies.
> the spreadsheet i am working on has 1 column with 2 possible answers, i.e.
> yes/no. what i need to do is separate the replies and then total the yes