Excel Calculation Error for formula to sum
I entered a formula of =sum(E11:E56) for example and excel did not return a
correct calculation. I checked the format of the cells and it is a custom
one. I checked for hidden values and could not find any (to my understanding
it will show a blank cell but if the cell is highlighted and it is a hidden
value it will show the number in the formula bar). The sum that Excel
returned is exactly 6033 over, which is a value that is included of what I
told excel to add for me. Any ideas? I changed the format to general, to a
number, etc and it did not help. Also, another item that is stra...How do you delete a file in Excel's VB?
Not much more to ask than that.
Any help would be much appreciated.
Use the Kill command to permanently delete a file. For example,
Note that Kill does not put the file in the Recycle Bin. To
delete a file to the Recycle Bin, see
Microsoft MVP - Excel
Pearson Software Consulting, LLC
<firstname.lastname@example.org> wrote in message
> Not much more to ask than that.
> Any help would be much appreciated.
...Running sum that restarts on each group
I would like to create in a query a field that calculates the running sum of
orders on each term.
I.e., each order with OrderDate, between BeginTernDate and EndTermDate,
should be added. the the running sum of the same term.
However, once we have orders from new term - the running sum must restart
from the first order of the second term.
The query is based on another query (instead of tables), that gathers all
it should look like:
Term BeginDate OrderDate OrderAmount Running
36 Jan 2006 Jan 2006 100 ...Make Default
Operating System: Mac OS X 10.5 (Leopard)
Email Client: Exchange
Hi I have a script to open entourage to configure a account, although the first time round for every user the script stops due to the message in Entourage asking would you like to make entourage you default browser. <br>
Anyone have a script to set this to default or any way of setting this so it never ask's ? <br><br>thanks
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=iso-8859-1; format=flowed
C...VS Debug Mobile
When I'm writing mobile apps in vb.net and want to F5 to deploy and run in
debug, I'd like to force the device's internet connection to be the one used
rather than the PC's internet connection.
Active Sync & Windows Mobile Device Center don't seem
to offer that as a configuration choice.
I want to be able to debug in VS on the PC while the app runs on the device
and uses it's internet connection.
I've tried both Work Connection and Internet, Automatic for "the computer is
connected to" setting.
Please suggest solutions.
...Converting Files #5
If anyone can/will convert version 2.0 files so I can open them in 2002, let
How many files? I will convert them for you. Are you certain they are 2.0 files.
Use to be Publisher 2002 would open these files, but a Window security update
mary-sauer at columbus.rr.com
Mary Sauer MSFT MVP
"Jerry" <Jerry@discussions.microsoft.com> wrote in message
> If anyone can/will convert version 2.0 files so I can open the...Making a Pivot chart from 3 differnt sets of data / worksheets.
Hi, I have 2 workshsheets of data with a list of delivery dates of about 10
different products over the last 3 years, (i cant combine these to just 1
worksheet for other separate reasons) and a 3rd worksheet with a column of
the same products and dates that some of these products became faulty and
were sent back to me .
On a 4th worksheet, I am trying to do a graph that looks at the 3
worksheets and plots pivot table of dates and amount of each product
deliveries & returned to me. So as i select ,say, product A from that pivot
list, it produces a graph for these 3 variables (dat...Payables check batch stuck in "Work"
I have a check batch that is stuck in "Work" status.
I've read several of your responses here and have looked both in Print
checks and in post checks but the batch is not available in either location.
There are about 1000 invoices attached to this check batch (actually just 1
check) so I really need to get this figured out!
There is a knowledgebase article about stuck batches. The old article id is
18064. The heading is "Unable To Post or Unmark a Batch For Posting."
Charles Allen, MVP
"Gwen Staples" wrote:
> I have a check batc...hyperlinks between excel and work when e-mailing
I have hyperlinks between cells in an Excel worksheet and text explanation of
the cells in a Word document (the explanation are too voluminous for cells).
Works great on my computer, but when I e-mail the files to others the path to
the hyperlinks no longer work. Is there a way to have a "generic" path as
long as the recipient put the files in one folder?
...making a transfer show up in the budget
I am running MS money 2006. How do I make a transfer show up in my budget?
I have several liabilities and credit cards, and I would like to make a
budget with the monthly amount owed to each creditor showing up in my
budget. The MS Money 2006 standard program does not allow me, as far as I
can tell, to make a monthly transfer to a credit card or liability show up
in my budget, unless I make it a category. Any help with this is much
See http://umpmfaq.info/faqdb.php?q=124 for the short answer. You may be
more interested in "cash flow" than &qu...making tickets
what is the best way to make numbered tickets using
Hi lc (email@example.com),
in the Microsoft Office Publisher newsgroup
|| what is the best way to make numbered tickets using
|| Publisher 2002?
Check out the following link:
Microsoft Office Publisher MVP
Official Publisher MVP Site:
This posting is provided "AS IS" with no warranties, and
confers no rights.
>what is the best way to make numbered tickets using
>Publi...Custom Application performance dll : NOT working on Perfmon 2003
I have a performance dll which pulls up custom counters from my
application as per the performance dll spec.
It works fine with XP and shows values when invoked by perfmon. When
my application is run on windows 2003 the perfmon of 2003 does not
show any values. It shows "---" for values. If the same process that
is running on win 2003 is monitored from a perfmon of XP it shows the
right values. Any ideas as to what could be wrong.
Thanks in advance
...How make a favorite for all users in Ex2007/OWA/Documents area?
I am playing around with OWA in 2007 and exploring the "documents" feature of
OWA that allows users to view Windows file shares by UNC.
There is the individual "add to favories" option, but does anyone know of a
way to administratively specify a favorite for all users? The alternative
seems to be logon as each user to setup the same favorite--surely that is not
the only way?
Thanks for any help!
...Reversing name values in a field
I have a field called CustomerName that has values that are last name,
first name. So there is a value of Smith, John which is John Smith. I want
to preserve the value in this field but create a new field called
CustomerName1 that has John Smith in it. It would need to somehow reverse
the values based on the comma delimeter and then get rid of the comma. Can
LN = Left$(CustomerName, InStr(CustomerName, ",") - 1)
FN = Right$(CustomerName, Len(CustomerName) - InStr(CustomerName, ","))
"ChuckW" wrote:...How do you change cells with formula's to the value or text?
In lotus it is possible to change the formula in a cell to the text or the number that that formula returns. Of course, you can not reverse it, but in is very helpful sometimes. Is that possible in Excel
CTRL + ~ will toggle between formulas and values
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------...Rules that don't work-OL2007
Is MS ever going to put out a version of OL in which rules actually work?
I just upgraded to Office OL2007 from Office OL2003, thinking that one of
the benefits would be that my rules would start doing what they're supposed
I have a rules that work fine if I see that a subject message has gotten
through, and I manually run the rule, but the rule(s) don't do their stuff
automatically when the message arrives. I've been very careful about
ordering the rules, so I'm certain that the rules are executed in the
correct order. Doesn't matter.
Are OL rules just a...Microsoft Dynamics CRM 3.0 Mobile Supports Windows Mobile 5.0
Microsoft CRM MVP
Can u give waht are the models Microsoft Dynamics CRM 3.0 Mobile
John O'Donnell wrote:
> John O'Donnell
> Microsoft CRM MVP
...Outlook Calendar Resources becomes Attendee after edit
In Outlook 2002, you can book a meeting with a Resource
in your calendar. However what is happening is when this
person edits the meeting with a resourse in it the
resource becomes an Attendee. Any Ideas?
...AN OPPORTUNITY TO MAKE $$$
THIS REALLY WORKS IF YOU FOLLOW THROUGH!!!
MAKE MONEY!!! MAKE MONEY!!!
MAKE THOUSANDS OF "$$$" !!!
I found this "NETWORKING PROJECT" on a bulletin board and decided to
All I say is, it "WORKS".
All it takes is a small INVESTMENT of your "TIME" AND "less than
INTERESTED??? E-mail: "firstname.lastname@example.org" for DETAILS.
...How do I make the X-Axis increase in scale with the quantity?
For example: If I have the values 1.5, 3.5, 8.7, 9.9 in the x values for a
line graph, is there anyway to make them spaced apart so that they are in
scale with eachother... Like so the distance between 3.5 and 8.7 is larger
than, the distance between 1.5 and 3.5?
Create a XY Scatter chart. It, and a bubble chart, are the only 2 that
allow for cardinals values on the x axis.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <F2D3DC58-86D3-4D21-9D57-F704A78941FB@microsoft.com>, =?Utf-
8...how do you make all incoming emails bold?
"Beth" <Beth@discussions.microsoft.com> wrote in message
I could've sworn there was a message here, but when I looked the body was
completely blank. Oh well, guess the poster really didn't want to ask a
how do you make all incoming emails bold?
"Vanguard (NPI)" wrote:
> "Beth" <Beth@discussions.microsoft.com> wrote in message
> I could've sworn there was a messag...Sum of multiple numbers from query
I've got 3 fields that the user will put the numbers in I want to get a total
of all 3 fields.
total field: TotalPSS-SR
need help how do I make the query work?
Add an additional field to your query:
[TotalPSS-SR] = [ReExp] + [AvoidNumb] + [AutoArousal]
"Kim T" wrote:
> I've got 3 fields that the user will put the numbers in I want to get a total
> of all 3 fields.
> field names:
> total field: TotalPSS-SR
> need help how do I make the query work?
...How to make VLOOKUP work for this
I have a "master" spreadsheet where column A is a time column and every row
represents a second (in plain text format) such as 00:00, 00:01, 00:02....
00:59:, 01:00, 01:01, 01:02,... and continues on for 24 minutes... 23:59,
24:00. (1442 rows). Off to the side (I'm thinking of putting it on
another sheet though) I have a small table where I'll enter the time and
corresponding data I need populated in Column B, and will look something
like the following example;
My question(s) are, is the VLOOKUP function the best way to populate column
B with the values? It's ...Link for invite not working
Exchange 2003 sp2
When a user opens an appointment in OWA the url given for the appointment
does not work.
Example of the URl:
...Ignoring Negative Values
Like all things in Excel there must be a way...
Given a column of numbers (say for simplicity 5 numbers) how can you
use a formula to sum them and ignore any that are negative? (e.g. four
of our 5 numbers are 5 and the other is -5 I want my formula to display
20 and not 15 or 25).
Greetings from New Zealand
"solomon_monkey" <email@example.com> wrote in message
> Like all things in Excel there must be a way...
> Given a column of numbers (say for simp...