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!
> Aft...How do I convert Excel 2007 Spreadsheet to Access 2007 database?
I used to be able to conver earlier versions of Excel spreadsheets to MS
Access. How do you do this with Excel 2007 & Access 2007?
Excel has never been automatically convertible. Import the Excel spreadsheet
as an Access table then create new, empty tables in Access and import the
data into them as needed.
Arvin Meyer, MCP, MVP
"DaveG" <DaveG@discussions.microsoft.com> wrote in message
>I used to be able to conver earlier vers...Sum
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 ...Recipient Policy Not Working #4
Running Exchange 2003 (SP2), recipient policy is not stamping email addresses
on new mailboxes created (in User's AD properties, under email tab, there are
no addresses (smtp, fax,etc). Any advice appreciated.
You can generally get good event information by turning up the logging for
MSExchangeAL on the server running RUS to Maximum.
If that doesn't get you anywhere, have a read of this excellent 3 part guide
on troubleshooting RUS by Bill Long.
> Running Exchange 2003 (...using a UDF in place of a cond. format, b/c I need 4, not three
I know this is an age old topic here, and I'm really hoping that I don't just
get referred to another web page [that type of help of course has its place
and merits]. And if I had the time, I would have more fun going through docs
and notes to find out how to do it, but time is not something I can barter.
What I'm looking at is:
I'm thinking along the lines of an example where I normally set the borders
of my columns [except if it's the first row] in a cond. format via something
But, if I need that space for a Con...Word 2003 stops working
Never had a problem with Word 2003 in the 3 years I've had this program.
Suddenly, I have issues.
A few minutes into opening a Word document, or upon attempted close of the
document, I get a popup box with message "Microsoft Office Word has stopped
working. A problem caused the problem to stop working correctly. Windows
will close the program and notify you if a solution is available."
When I close the popup, sometimes a new blank "document 1" opens up
automatically. This happens with both Word docs and Outlook messages.
Can missing Form 140 Schedule C line names be added? If
...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?
...Publisher/Word auto saving to C Drive
I teach in a computer Lab and when students are editing text using Publisher,
it takes them to Word andafter editing they close Word, I get a "Permission
Error . . C drive." When I do it on my computer (has some admin. privileges)
How and where does one change where Word 'appears' to automatically save?
Can this be changed without giving all students Administrative Privileges?
...Why doesnt this work?
I have two sheets. The one called CorpClaims and one called Summary, the
latter is where I want the answer. On CorpClaims is a list of data with
various headings such as DateofLoss, Amount, DescriptionofLoss etc
On Summary is a small table that has Description of Loss down the left in
Column A, in row 2 is the applicable month (the input would be 01/08/2009 for
August 09 and formatted as Aug 09). Then the value part of the table would be
the sum of all amounts that fall under the Description of Loss, (which is
defined in column AJ) that fall in a certain month.
This may be the wrong place to Post this - I need some help with the
Using Outlook 2002 - When replying to most E-mail messages, all works great.
However, When I reply to a E-mail message created by a MDaemon user, the
message is replied to the "Send To" part of the message not the "From :
Example, If a message is sent to "Everyone" @ xxxxxx.com - (convention From
MDaemon to send to all mail boxes)- it goes out correctly and shows the
individual's address in "From": - it shows the original sender's address
(firstname.lastname@example.org). ...Send Receive All option is not working?
When sending out an email I select the Send/Receive All to send item from
outbox. I then have to click the Send/Receive All option again in order to
receive new incoming emails. Isn't that how Send Receive All is supposed to
work. To send out items in outbox and to receive new mail with a click of the
Thanks in advance.
...Link to other slides from table using c#
I'm looking to create links from a certain slide to another, and I need
those links to be from within a table.
I need it to be something like this:
pptApp = new
presentation = pptApp.Presentations.Add(Office.MsoTriState.msoFalse);
slides = presentation.Slides;
, 0, 1);
titleSlide = slides;
tableSlide = slides;
tableSlide.Name = "TableSlide"
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...How get global variable into report textbox ?
I've been trying to do this for 2 hours and am completely stuck.
I can display the variable with Msgbox but as soon as I try to set the text
box to the variable, I get an error (can't assign to this object)? It also
failed when I try to do it via the 'controlsource' Why is this simple
opertion so difficult?
>I've been trying to do this for 2 hours and am completely stuck.
>I can display the variable with Msgbox but as soon as I try to set the text
>box to the variable, I get an error (can't assign to this object)? It also
>failed wh...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,...Postmaster@domain.com messages get queued
I have a handful of domains that show up in my exchange queue that have
messages that will not send. They all have some sort of error message like
"The remote server did not respond to a connection attempt."
"Unable to bind to the destination server in DNS"
"The connection was dropped due to an SMTP protocol event sink."
The interesting thing is that almost all the messages are from "postmaster"
and are destined for bizarre domains like TPNET.DL, MAIL.HQ.COM.AR etc. What
exactly does this mean?
They're likely replies to NDRs to ...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...