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 ...OWA display problem
Our Outlook is performing normally when accessed
internally. When accessing by way of OWA, however, we can
see the headers, but cannot open the message. We can
compose new messages and send them. We cannot see the
message body in a preview pane.
It sounds like you might have URLScan installed on the OWA server. Please
have a look at the following article to see if it is relevant.
320089 XCCC: The URLScan Utility Does Not Allow You to Open Messages in OWA
Hope this helps.
Greg Mansius [MSFT]
This posting is provided &...PDFs do not display in OWA using FE/BE scenario, IE 6, Adobe Reader 7.0.7
My organization is currently running Microsoft Exchange Server
2003 SP2 in a FE/BE scenario with the FE serving OWA. We are
experiencing problems with our OWA users not being able to open PDF
attachments within OWA when they are using IE 6 (fully patched) and
Adobe Reader 7.0.7. After some testing, I have discovered the
Abobe Reader 7.0.7 and IE 6 (fully patched) - PDFs will not display in
OWA (no errors given)
Adobe Reader 7.0.7 and IE 7 Beta 2 - PDFs will display properly
Adobe Reader 7.0.7 and Firefox (fully patched) - PDFs will display
...Need help converting date time to date only
I have a column in my spreadsheet with date and time, you can see in m
attachment. I want to convert this column in to date only. Pleas
Attachment filename: sales - open orders test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=57210
Message posted from http://www.ExcelForum.com
without looking at your file you could use the following formula in a
and format this cell as 'date'
> I have a column in my spreadsheet with date and time, you can see in
...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?
...custom header date formats
How can I set the date format on a custom header? I know I can use
&[date] to insert the date...the problem is I want the date to display
in a specific format (ex: MMDDYY or MMDDYYYY)
Message posted from http://www.ExcelForum.com/
Use something like:
"Ron777 >" <<Ron777.firstname.lastname@example.org> wrote in message
> How can I set the date format on a custom header? I know I can use
> &[date] to insert the date...the problem is I want the...Incorrect Currency Displayed
When exporting data from a VB application to an Excel spreadsheet I am
finding that the wrong currency symbol is displayed.
OS used is XP. The XP regional settings and language are set for UK.
When the data is exported the display for the currency data on the
spreadsheet is a $ rather than £.
When I try to format the cells in excel to set the currency symbol the
dialog box displayed shows that the currency symbol for the cells is £ but no
matter what I do when I close the dialog box the currency symbol on the
spreadsheet is still a $ symbol.
Tr...Display different outgoing mail domain
We have purchased a domain name that we would like to use
for our email. ie we use Stargate as a mail provider,
but we want our outgoing mail to show
email@example.com instead of firstname.lastname@example.org.
You could do this in previous versions of Outlook (tell
it how to display outgoing email address), but I can't
figure out how to do this in 2002 Outlook.
Does anyone know if this can be done?
...displaying dates in UK format
I didn't write the original database and my knowledge of database design is
not good enough to duplicate the work already done.
With a variety of computers running Windows98 and/or XP, using Access2003, I
cannot get dates to display on my forms in UK format (i.e. dd/mm/yyyy or even
The computers in use all have the short date format set to dd/mm/yyyy in
I have read through http://allenbrowne.com/ser-36.html and tried the
formatting suggested there and it didn't work for me. I added it to "Lost
focus" and "OnExit" and ...Changed relationship; records no longer linked
I have a Corporates table holding details of company customers.
I have a CorpContacts table holding details of our contact persons at those
Originally I had a relationship (one to many) between Corporates.CorpName
I had a Corporates form which contained a CorpContacts subform displaying
the contact persons' details. All working fine.
But if we updated the name of the company i.e. Corporates.CorpName, the link
was lost and the contact persons were no longer displayed.
So I introduced new fields in each table ("CorpID"), i.e. some...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...Customer Membership Expiration Date
I have a customer who sells annual memberships to museum patrons, they get a
discount in the gift shop. She would like to set the expiration date on the
membership at the time she sets up the customer in the database. Does anyone
have any ideas how to accomplish this? Add-Ons available? Thanks for your
time and knowledge.
You can use one of the customer custom date fields, set it equal to the
expiry date. Then customize the HTML status bar to indicate whether the date
in that field is less than today.
Easy as pie, although if you have every tried making a pie it is actually
very h...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,...IE8 displays page cannot be displayed...
I am writing a WEB Service that is using Negotiate protocol with the MS api
AcceptSecurityContext. If the browser is not logged into the domain but a
group and tries to access the service the browser will respond with a
WWW-Negotiate header passing a token to the service. However the browser will
return a Page Cannot be displayed if the output of the AcceptSecurityContext
returned a SEC_I_CONTINUE_NEEDED and the output buffer is sent back. I would
have expected the browser to prompt for credentials or make a new request and
choose another option when the cycle repeats. If this is...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...SnapShot Date?
This is for HQ looking at 114 active SO stores. The report is generated in
HQ> Rpts> Items> SnapShot Store Price List.
What is it that defines the snapshot date? I always looked at it from the
inv side post physicals, request item count and reconciliation - but now I am
looking at store level pricing (they set their own). I can see the snapshot
date is different not only on different stores, but also on different line
items from the stores.
So far, my best guess has been that the snapshot date is based on a date the
store has set or changed their pricing (like p...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 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