How do I add numbers in visible cells using Excel 97
I need to add values in visible cells using Excel 97 using
a formula instead of adding values of each cell
If you mean your data is filtered, check out the SUBTOTAL function -- eg:
Support Boris - visit http://www.ncadc.org.uk/letters/newszine36/boris.html
If you are hidding the rows using a filter, then look in help at the
Subtotal worksheet function.
Other than that, there is no built in function that ignores hidden cells.
Perhaps there is a cell value condition you can check - so you could use
Sumif, use the c...User removed Anonymous permission from Calendar...how to get it back
A user has deleted the Anonymous permissions from their calendar and I am unable to find a way to get it
back. Does anyone know what can be done to add this back to their calendar. TIA
Fuzzy Logic <firstname.lastname@example.orgREMOVETHIS> typed:
> A user has deleted the Anonymous permissions from their calendar and
> I am unable to find a way to get it back. Does anyone know what can
> be done to add this back to their calendar. TIA
In that user's Outlook, right-click on Calendar, properties, permissions
tab. Add Anonymous, and do whate...add cell
i have a long list all in one column. the data in the first fifteen (
thrue 15) is related and must be kept in sequence. the first fiftee
cells repeats with changes in its data for the next fifteen (16 thru
30) and also must be kept in sequence. this repeats over and over for
list of about 4000 cells.
what i need to do is this: i need to insert an empt
cell betwwn each group of fifteen cells.-to seperate them. between
15 & 16, 30 & 31 etc without disturbing the continuity of each 15 cel
thankyou so much
---------------------------------------------------...How to add a new domain to Exchange 2003?
We are running Windows 2003 and Exchange 2003. Our email domain is
"mycompany.com". We would like to tell Exchange also except email for
domain "newdomain.com". How do I add that at the Exchange level? I now
about DNS, MX records and all of that. We don't need all of that, we are
just running a test. Thanks for any and all help.
"Clayton Sutton" <n...Add-ons and verticals
Hello CRM guru's,
We publish a website on which we try to give an overview of all add-
ons and verticals that are available for Microsoft CRM. We do have
over 100 add-ons listed, but only a few verticals. Do you have any
vertical that you want to share with the CRM community? Don't hesitate
and post them on www.pimpmycrm.com via the comment form or via the
emailadres that is listed there.
This is a free website, so you have nothing to lose. Of course, if you
are looking for extra functions, add-ons or verticals, you can also
find them there.
I have few, can you listed that on your si...add wave file to avi file
Can any one give me a working example on how to add a .wav
file to a .avi file. I used
I did get the .avi file working. but when I try to
it is not working at all.
I also tried the code at
and code at
It is not workine either.
Is the play time of the .avi has to be the same as
the .wav file?
Thanks for help.
...Help needed to add commets, arrows, etc to existing graph...
I am wanting to add comments and arrows (that look proper) and fill i
the area between two lines on a line graph i have created in excel. Ca
someone please guide me on how this may be done...
I was thinking:
i. there may be a way to do it in excel that i am not aware of,
ii. there may be another charting program which will draw the chart
with all the frills from data exported from excel,
iii. there may be another program that allows me to add stuff t
already created excel charts,
iv. something else.
My aim is to export these graphs to word - they will form part of
report i am writting.
An...Outlook 2002: can't add new contacts, or new calendar entries
I've been struggling to get Outlook 2002 to add new
contacts. They are created, but the name won't appear.
Also when I try to add an event to the calendar, nothing
I have had these problems since Outlook 2000, which was
the main reason I upgraded to Office XP Pro. But it
hasn't solved the problem.
I also find I can't get the auto archive to work
properly, it often stops. I can't manually drag/move
older emails to the archive folders, only newer ones.
I've run the SCANPST program a few times, no errors.
I've been trying to reduce the siz...Remove text from a cell
I have some data in a spreadsheet which is an output from another program.
One column has a series of numbers in it, each with the suffix of "kb" and I
want to remove the kb from each cell so that I can sort by number. Is there
an easy way to do this without having to edit each cell individually (I have
about 600 rows!)
one way: Use 'Edit - Replace'
the other way: use the formula
in a helper column
>I have some data in a spreadsheet which is ...Outlook removes in box items upon reply
When I reply to an item (all items) they are removed from
my inbox and disapper -- not in deleted items -- I cannot
find them. What is up with that and how do I fix it ?
"Jeff J" <email@example.com> wrote in message
> When I reply to an item (all items) they are removed from
> my inbox and disapper -- not in deleted items -- I cannot
> find them. What is up with that and how do I fix it ?
View-Current View-All messages.
When I look at that, it does nothing. If I cahnge the
View to "View Me...ppt viewer problem
I am using lulu.com to self publish a ppt presentation. The ppt presentation
has been "packaged for CD" and has all the files automatically generated by
ppt for a portable presentation using ppt viewer.
Here is my problem. The publisher creates an ISO image file of all my files
and then proceeds to create my CD. One of the restrictions of ISO is that
all file names be 8 characters or less. All my files conform to this
BUT some of the files generated by ppt, such as, pptview.exe.manifest and
microsoft.vc80.crt.manifest, do not conform to this standard. As a...Crystal Report Viewer Error
When trying to run reports through the CRM I get the following error:
Information is needed before this report can be processed.
This shows up in the popup window where the results of the report would
normally show before you would press the print button.
This error is caused by
1)Installing Microsoft CRM on a computer that has an underscore in its name.
2)Security issues related to domain and Microsoft CRM setup.
Microsoft has explained the causes and how to resolve this error in the
http://www.microsoft.com/download...How do I change a shape in Visio for a process flow diagram
How do I change a shape in Visio for a process flow diagram? I have an
existing process flow diagram in Visio and want to change multiple shape
types to other shape types without losing the data on the current shape. I
don't want to have to redo the connector lines & text inside each box. Help.
On Thu, 8 May 2008 08:43:03 -0700, Chris
>How do I change a shape in Visio for a process flow diagram? I have an
>existing process flow diagram in Visio and want to change multiple shape
>types to other shape types withou...add-in
When logging onto Outlook the following message show
up: "The add-in 'C:\pavfn\exch\PavExCli.dll' could not be
installed or loaded. THis problem may be resolved by
using detect&repair on the Help menu. Unable to load
c:\pavfn\exch\\pavExCli.dll. You may be out of memory,
out of system resources, or missing a .dll file."
I have done all of the things mentioned and am certainly
not out of memory or system resources. I have asked this
question before many months ago and had to cancel
something. Just do not have the message that was sent to
me. I have deleted ...Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle
This is a multi-part message in MIME format.
I'm getting this message when trying to clear tempdb
DBCC SHRINKDATABASE (tempdb, 10) WITH NO_INFOMSGS=20
Msg 5054, Level 16, State 1, Line 1
Could not cleanup worktable IAM chains to allow shrink or remove file =
operation. Please try again when tempdb is idle.
Msg 5054, Level 16, State 1, Line 1
Could not cleanup worktable IAM chains to allow shrink or remove file =
op...Visio software diagram?
Does someone have a good Visio template to document software
architecture? I need a good intituitive drawing that will include both
the tasks (proecesses and threads) and data structures. Any ideas or
suggestions of other tools that can do this well?
On 12 Jan 2006 19:02:22 -0800, firstname.lastname@example.org wrote:
>Does someone have a good Visio template to document software
>architecture? I need a good intituitive drawing that will include both
>the tasks (proecesses and threads) and data structures. Any ideas or
>suggestions of other tools that can do this well?
You...Excel Visio Linkage
In my job I generate chemical plant layouts. Most of the work is done in
Excel or ends up there. One thing I end up doing is using Visio to make
scaled layout drawings. If I had an excel spreadsheet with data in two
columns; one Name, and two size, can I use Visio VB to read the drawing
sheet scale, and then draw circles which are scaled to match the size in
Excel and contain the Name. I would propose that the names would be a letter
and two numbers for example C01, C10, T01, or T10.
Any guidance, or links for examples, on how I might do this are appreciated.
Thanks in adva...Editing a Visio drawing in Power Point sent via email?
I am trying to edit a flow-chart created using Visio 2000 and sent to me in a
Power Point document, via email. I am using Visio Professional 2003. Thanks.
is it really embedded (then of course where is the vsd file that it is
related too)? Of course the flow chart addons are incompatible anyway.
"jim@techheat" <jim@email@example.com> wrote in message
>I am trying to edit a flow-chart created using Visio 2000 and sent to me in
> Power Point document, via email. I am using Visio Pro...converting hand drawn sketches into Visio Cross Functional Horizon
I am new to Visio 2003 . Can anybody tell me how can one convert hand drawn
sketches into Visio Cross Functional Horizontal diagrams?
Are you asking about a way to scan images into Visio and transform them into
drawings? Or are you asking how to assemble a Cross Functional diagram?
To make a Cross Functional diagram, you first choose how many bands to
create. Then you click on the headings for the bands to change the text to
the names you want. Switch to the Basic Flowchart shapes in the Shapes
Window and drag out the Process shapes to create the steps in you...Add a number based on list of criteria ??
Example: Cell A = 50, Cell B = 96%, Cell C = Cell A + (Cell A x Cell
B) = 98
I want to be able to compare the list of criteria and add a number to
Cell C accordingly
For example: If Cell B is between 95 and 100%, Add 1 to the total in
If between 85 and 94%, add 2... etc.
There are more than 7 so I know I can't simply nest If statements...
Any advice on how I could fairly simply accomplish this?
Put your % bands in a table (say in J1:Kx, e.g.:
1 0 11
2 5% 10
3 15% 9
10 85% 2
11 ...Exchange Failing when Removing GC from same box
I am trying to install Exchange 2007 but cannot because I have two Windows
2000 DCs with GCs. The two Windows 2000 DCs happen to be on the same boxes
as my Exchange 2000 cluster. I have two other Windows 2003 boxes in the same
site with all FSMO roles and both are GC.
I'm in a catch 22 because I cannot install Exchange 2007 and when I remove
either the GC role from the Windows 2000 boxes or demote them, Exchange
Has anyone come across a situation like this and know of a solution?
In order to install Ex07, you will ne...How do I remove the pop up message when saving a CSV
I use alot of CSV files and when I save them I get the
message "may contain features that are not compatible
with csv". Is there a way to turn this off and just save
If you do the saving with VBA you could add the line
> I use alot of CSV files and when I save them I get the
> message "may contain features that are not compatible
> with csv". Is there a way to turn this off and just save
I'm just opening them and changing a piece of data and
closing t...Visio 2007 Std
I added a couple of shape data to a shape (Server shape). I recognized that
my labels are switched in lines. Like I define a label called "IP address"
it used to be in line 2. Sometime in between it moved to line 5. Don't know
why. But some more strange things happened. I defined a label "data centre"
I gave it a type "fixed list" and entered some info's there. Everything
looked fine I checked OK and in between again I recognized that my type
"fixed list" was gone. The label was still there but the type changed to
"string" and my...Outlook 2003 viewer changes
Is there any way to remove the display of:
+ Date: Last Week
+ Date: Monday
+ Date: Tuesday
+ Date: Yesterday
- Date: Today
I find these drop downs annoying and would prefer just to have the
mail senders, subject, size, etc. I don't need them categorized by
the day of the week.
e-Mail: chris at cwaiken dot net
"Christopher W Aiken"
| Is there any way to remove the display of:
| + Date: Last Week
| + Date: Monday
| + Date: Tuesday
| + Date: Yesterday
| - Date: Today
| I find these drop downs annoying and would prefer just to have the...Re: 'Server XXXX Not Available.' When Trying To Add a Process Serv
We have contacted our Partner and they say that we have to pay $2,500.00
additional to get the process server as it is not the part of Systems
Manager, any more.
Our product say " New Enhancement plan" and I see Systems Manager is
installed but not the process server..
By BRL; you mean Business ready license?
"Viol-8-r" <firstname.lastname@example.org> wrote in message news:...
> Thanks, Mariano,
> Yes, we are checking it with the Partner and sure I will update you about
> the outcome.
> "Mariano Gomez" <MarianoGomez@discussions....