Excel on website
I have an Excel file which opens maximum at my desk, but it opens minimum
when I view it on my company's intranet. I use FrontPage 03 and Excel 07.
After moving the file to server and linked it to the page
I got it!
> I have an Excel file which opens maximum at my desk, but it opens minimum
> when I view it on my company's intranet. I use FrontPage 03 and Excel 07.
> Please advice!
Hi, I just found this "feature" at Excel formulas today.
Please, have a look at: http://danielgudang.multiply.com/journal/item/192
(in portuguese, but images show all)
Let me explain:
some cell C1 = sum (C2:C5)
some cell D1 = sum (D2:D5)
some cell E1 = sum (E2:E5)
A1 = C1 - D1 - E1
B1 = C1 - (D1 + E1)
A1 = B1 ??? Oh, not always!
Sometimes A1 will be +0, sometimes -0.
It's a feature of any application that uses IEEE double precision
floating point math (e.g., every commercial spreadsheet I know of).
It's the result of having finite precision ...sorting text & numbers
I have a large list that I want sorted like this:
Ward 2 & 3
When I sort it, it says:
Ward 2 & 3
If I just take out the words Ward and Wards, it makes some of the
numbers into dates, and does something else to some other cells that
returns a big number. Anything I can do?
billjr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25927
View this thread: http://www.excelforum.com/sh...Question about Exchange 5.5 error message
I have two Exchange 5.5 email servers running is the same domain, but
geographically separated by 300+ Kilometers. I was curious to
understand why a message created on EXCH2 would not go out its IMS
connector but out the IMS connector of EXCH1, which again is at a
The MTS-ID of the original message is: c=US;a=
3499 (000B09B6) Host unreachable
firstname.lastname@example.org (Pat) wrote:
>I have two Exchange 5.5 email servers running is the same domain, but
>geographic...Embedded Excel worksheet in PowerPoint
I'm working with an embedded excel worksheet in powerponit. The doc is sent
to me and if I have to edit the worksheet, I find that some cells have
missing characters once I open the worksheet to edit it. It appears that
characters beyond some length (256?) are being truncated off. How do I
resolve this so I don't have this problem again?
This kind of problem may occur if the material was inserted into the embedded
worksheet via copy/paste from an external sheet. A reliable approach is to
open the embedded sheet first, and from that sheet do:
File ...Excel 2003 01-27-10
Hi all, hopefully you can help me.
In cell B21 the user will always input an email address, i have created a
button and now need the button to automatically email the email address in
I then need it to default and save to a specific location with the file name
automatically generated from b12.
Please help. :)
...Purge data based on another Excel file???
I am attempting to purge data from a large list based on data in another
document. I have the files I want to remaove in on file and the file I want
to remove them from. There should be simple way to do this no?
...Title Block Question
I just started to use one of the small title blocks supplied with Visio
2003. Previously I used a simple text box. The title block has a nice
feature that automatically inserts today's date. That is fine for today,
however, when I open the file later, the date is automatically updated.
Is there a way to use the automatic date insertion when first dragging the
title block onto the drawing and then freezing the date? Or should I be
thinking about a macro to write in a fixed date?
Thanks foe your help!
This type of action can be done using the EventDrop cell in...A question regarding coordinates of points within a chart
Can anyone explain how x-y coordinates for points within a chart can be
accessed via a mousemove event? I realize this will require quite a bit of
coding, but I would like a little comment box to appear for any given point
on an X-Y scatter I have. The data set consists of around 27000 points, and
I would like the mousemove event to trigger a lookup into a table that
contains a fairly lengthy descripion of each point.
Take a look at Jon Peltier's article on chart events . . .
then, take a look at this post ...Exchange 2003 Question #6
What would be the implications of installing an Exchange 2003 server on my
network, when an Exchange 2000 server already exists?
A part of the Installation and setup process is to prepare AD for the
Exchange implementation (forestprep and domainprep). If you are
attempting to install Exchange into the same AD, then it would assume
that the same Exchange Org will be used for the new installation of
Exchange, causing the 2 to be semi connected (also would depend on
site configuration, etc)
When you are mentioning "on my network" - are we assuming that you are
using ...Sorting Alpha Numeric
I have a list of alpha numerics I wish to sort but they are coming up as the
Excel 'default'. I prefer the desired result. Any thoughts? Thanks
Original Sorted Desired
D10 D07 D07
D09 D09 D09
D07 D10 D10
D11 D105 D11
D12 D11 D12
D20 D117 D20
D117 D12 D105
D105 D20 D117
your data isn't sorting properly because it is type text, which always sorts
alphabetically left->right (so it won't distinguish between a 1 in the tens
or hundreds place). I have two suggestions:
1. If...EXCEL 2007
I have a GIS application which uses .dbf files (not sure if they are actually
Dbase files). When I need to append data (fields) to the files, I have a big
problem in that excel 2007 no longer allows save as / export to .dbf files.
If I try bring the data in MS Access and save as .dbf files, I have untold
problems with the GIS application... The only way I have been successful with
this is to find a user with an older version of excel, insert the data as
database columns and then save as .dbf
Any suggestions as to how I can get around this with out purchasing a
...in Excel: How do I change "selected cells" highlight color?
When I select cells in Excel the shading is so light (blue) that I can barely
tell which cells are selected from those that are not. Can I change the
background color of cells that are selected?
Assuming Excel 2007 this is a known problem and as yet no patch for it.
I don't have Excel 2007 but I have read that playing with your Contrast can help
Gord Dibben MS Excel MVP
On Tue, 10 Jun 2008 12:51:00 -0700, flameretired
>When I select cells in Excel the shading is so light (blue) that I can barely
>tell whic...email from excel workbook button does nothing
In my old version of excel(2003) as long as i had outlook open i could email
directly from the worksheet. Now i have office 2007 with "windows mail" when
i press the button in the "quick access" tool bar it does nothing.
I have tried having widows mail open when I do it too but the only way i can
send is by making file attachments. seems like the long way around.
Is there something I am doing wrong? I have tried to read some of the
previous posts and dont understand anything about codes ect.
Is Windows Mail your default m...Delete duplicate rows from a list in Excel
Below are instructions on how to "delete duplicate rows from a list in
Excel". I learned about this tip from the Microsoft Office Assistant
website. However, each time I try step 4, my list is not filtered and
no records are hidden. Is there a secret I am missing to make this
Thanks for your help!
Microsoft Office Excel 2003
Microsoft Excel 2002
A duplicate row (also called a record) in a list is one where all
values in the row are an exact match of all the values in another row.
To delet...How to tell Excel to insert cells and shift down from Access
I have Access 2003. I am trying to tell Excel to insert cells and shift
cells down from Access, with this line of code:
But Access does not like that line. It gave me run-time error 1004. I
know if has to do with the part Shift:=xlDown
Can you suggestion what I can do?
Thank you in advance,
"Ben" <Ben@NoSpam.com> wrote in message
> Hi all,
> I have Access 2003. I am trying to tell Excel to insert cells and shift
> cells down from Access,...Text Wrap in Excel 2002
I have been having difficultly wrapping text. I merge
several cells and wrap text sucessfully. However, if I
go into one of the cells and add a couple of sentences
and enter, my text that was wrapped perfectly is simply a
string of #########'s and I can't view the text correctly
by changing the row height or reformatting (even though
it is all still there - as I can see in the edit box -
when my cursor is on the text box).
Try formatting the cell as General.
> I have been having difficultly wrapping text. I merge
> several cells an...Excel Version When Posting Please State Your Excel Version!!!
On Jan 8, 6:58=A0pm, "Tyro" <T...@hotmail.com> wrote:
> Subject: Excel Version When Posting Please State Your
> Excel Version!!!
And Please Include Your Questions and Comments In the Body of Your
Not just in the subject line, even if it simply duplicates the subject
Some news readers truncate the subject line. Some news servers do not
permit you to reply to articles with empty bodies. Some news servers
seem to reject such articles when they come in from the network, or
perhaps the originating news server does not push them into the
That ...EXCEL Cell Formatting: Custom or Conditional
At work I have Excel 2002 and I have some cells that I import data in
from the mainframe. I have a table where there is a column for GENDER
(MALE or FEMALE) that I would like to see shown as "Male" or "Female"
(mixed case). Is there a way to change all upper case to mixed case
using either CUSTOM formatting or CONDITIONAL formatting? I would
prefer not using a macro if there is something simpler. I know that
=PROPER() produces the correct result, but I don't see how I can use
this unless I'm referencing another cell. I would like to be able to
just change what fa...Excel Formulas
I have a spreadsheet showing whether customers have paid their debts or
Each row represents a customer and details of the debt and the last
cell in the row states whether the debt is "PAID" OR "UNPAID".
Where the word "PAID" appears in a cell, I want to write a formula that
will move that whole row to a different location on my sheet.
I eventually want to record this action on a MACRO, so that every time
I run a MACRO on my accounts spreadsheet it will take the updated
information of customers marked "paid" and put in a seperate
Ple...how can I change the a,b,c, column headers in excel to names
I've tried and can't figure out how to change the column header from a,b,c,
etc. to names for each column. Any tips are appreciated
You can only show A,B,C...,IV or numbers: 1,2,3,...,256
But you could put your names in Row 1 and then select A1, then select A2 and
click on Window|Freeze panes.
> I've tried and can't figure out how to change the column header from a,b,c,
> etc. to names for each column. Any tips are appreciated
I am trying to create a formula so that from a list of say 2000 of which 1999
are "NO" and one will be a digit, what formula can I use so that this one is
selected out of all of them?
I want to create a formula so that all the cells are checked and it picks
the 7 because it is not a "NO".
Might try an Excel newsgroup... Or Access
Mary Sauer MSFT MVP
"A.S." <AS@discussion...Copy/Paste Excel Macro
What I'm trying to do is automate a process using an excel macro. What
I need the macro to do is to look for a blank cell in a range of data
in Column A, and whenever there is a blank space within that range,
paste some specific above information into this row. (I'm formatting
an excel file after taking it from another program). I would greatly
appreciate any help!
You could record a macro to filter on blank in coloum A then paste a formula
+cell above- this would then fill in your blanks
Thanks for your help
>...How do I print excel doc from an email
I dont have excell but I received an excell document by email. I am trying to
find a way to print the doc. Is this possible? Thanks for any help.
Get the free Excel viewer
Regards Ron de Bruin
"kevinb" <email@example.com> wrote in message news:BB654C4D-8AB3-4D98-89C7-49DA1BDE0C42@microsoft.com...
>I dont have excell but I received an excell document by email. I am trying to
> find a way to print the doc. Is this ...format question
Installed a 2nd HD and have partitioned into E: and logical F:. I have
programs on E: right now. Can I format E: without destroying the partition
that formed F:? Thank you, Steve T.
Yes you can format E drive without destroying the logical drive F. If the
OS is also in E (with your programs) then not only you will lose it but you
will need to format the E drive using Windows OS CD or any external bootable
CD that contains format.com or Format.exe. If the OS is in C drive then you
can format it from within Windows XP using Windows explorer and
right-clicking on the drive ...