Excel Not Opening using OWA
We have an excel file from a certain sorce that will open blank or if trying
to save will save as 0kb from OWA, file opens fine using normal Outlook 2003
Any clues - help much appreciated
"Ivo" <Ivo@discussions.microsoft.com> wrote in message
> We have an excel file from a certain sorce that will open blank or if
> to save will save as 0kb from OWA, file opens fine using normal Outlook
> Any clues - help...Last Date 05-17-07
I am setting up and inventory DB
I have a parent table (Material) and a child table (Material Count)
The child table has a field (Date Entered)
What I need to do is to be able to extract the record in the child table by
the last date entered,
This will allow me to construct a report that list all of the records in
the parent table and the last date inventory was taken on that item
Thanks for your help
...Edit Comments Formatting
How would I edit the formatting of more than one comment
in Excel? I am not familiar with Visual Basic, but I know
I might be able to change the New Spreadsheet Template.
However, I want to know if I can the formatting to a pre-
I know I can search comments by the following list of
However, how would I change the formatting from 8 inch
Tahoma to 10 inch Arial without changing the formatting of
Help would be appreciated. Thank you.
The following code will format all comments in the active workbook:
'=====...OWA 2003 An Unknown Error Happened
When I attempt to create, reply or forward to a message in OWA 2003, the appropriate
window opens, but is blue/grey in color, and contains only this text, centered in the
! An unknown error happened.
The exclamation point is dark red, the text is black.
I've dumped the client browser cache, removed all unnecessary controls in
"C:\WINDOWS\Downloaded Program Files", and rebooted the system. I've cleared the SSL
state. I've reset the browser advanced settings.
The problem persists. Any suggestions?
(substitute 'tcsys.com&...Dates #4
Can any one of you please help me to get rid of the default excel dates to
standard format dates.
You need to set the format yourself, Format>Cells>Custom
(replace somewhere in email address with gmail if mailing direct)
"mnair" <firstname.lastname@example.org> wrote in message
> Can any one of you please help me to get rid of the default excel dates to
> standard format dates.
Go Control Panel->Regional and Language Options: Click Customize->Date
format. C...Additional domain smtp primary address -problems with owa & active
We are going to be adding a second smtp domain to our exchange enviroment,
are users will be split one half having abc.com as their primary (reply to
address) and the
other half having xyz.com as their primary (reply to address). Given that
enviroment is originally installed under abc.com, will there be any issues
with the users' whose primary smtp address is xyz.com accessing owa and using
active sync? I have read someone that exchange has problems matching primary
smtp addresses that don't match the exchange virtual directory default when
owa or active sync?...Problems with OWA after Installing SP1
We recently installed Hotfix KB31464 and Service Pack 1 for our Exchange
Server 2003. However, after that, we're having problems with our Outlook Web
Access system. From IE, the page says it is 'loading' but it never does
anything else. Clicking upon the different links (contacts, calendar, etc)
does nothing. If you open the page in Firefox, it links to the right folders
(contacts, calendar) and opens them up (like emails, events, contacts), but
the images aren't showing up (showing up as broken links). Is anyone else
having this problem or know how to rememdy this?
I to...Pivot Table date format
The "data" worksheet has the correct date format -mm/dd/yy. There is no time
When in the pivot table worksheet the date is showing up as :00, :01,
:02...... What appears to be a truncated time format.
I have tried to set the date format in both the data worksheet and the pivot
table worksheet with no changes evident. The data worksheet will change but
this is not carried over to the pivot table worksheet.
Setting the format in the pivot table worksheet has no effect.
Hi Irene, I have just tried to reproduce the error that you are seein...re: slow OWA
I'm having problems with an exchange 2003 server standard edition
running webmail and only webmail. This is the only server and is the domain
controller aswell running windows 2003 server. I am using Forms based auth
and things will all work fine and then all of sudden someone can click on
their inbox and everything will grind to a halt. Things become very slow and
it is unusable. The CPU, Disk and Mem usage are all fairly normal and i
cannot see anything that sticks out to me. The people are accessing it from
other sites only when this is happening internally it seems to work fine...OWA URL and OWA authentication
I'm trying to change my owa url. Actually is https://mydomain.com/exchang
but I dont want users have to type the /exchange. I went to IIS into default
web site properties into home directory tab, and than check redirection to a
URL and than type /exchange, but may I forgot something because it doesn't
The other question is : I would like that the user have to type their e-mail
address and password to get into the owa. At this time, they have to type
their user domain name and pwd.
For the redirection to work, you'll also need to check the box marked "A...Week number from date
Hi all, I have the code below in a text box which is returning the week
number from text box 118 on a report, it is returning week 4 when the date in
the text box is 18th January 2010 when actually it should read week 3, can
anyone tell me what is wrong? Thanks
Check the options for designating the first week of year.
Constant Value Year Starts with Week
vbUseSystem 0 Use the system setting.
vbFirstJan1 1 The week in which January 1 falls (the
v...Negative Cell Format
I would like to know if a cell can be fomatted negative
so that any subsequent entry appears as a negative number
with out having to enter the minus sign.
If you only want it to "appear" to be negative:
Note that positive values displayed with the leading minus sign will not
be treated as negative in calculations.
If you want to have the values automatically be negative, try this event
macro (right-click the worksheet tab and choose View Code):
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Ta...OWA: Best course of action when OWA is generally defunct?
I have an Exchange 2003 server that was running beautifully until we
found we had a problem managing public folders from Exchange System
Manager, requiring a new SSL certificate to be generated. We were able
to fix the System Manager problem, but then we found that OWA was
broken. We get the dreaded "Page cannot be displayed" error when
trying to go in on port 443, and attempts to go in through 80 results
in a 404.3 error (must be viewed over SSL).
Generally speaking, the Exchange server seems to be in good health - -
it's only the Web-based parts of the system that seem hose...Formula for calculating the diffrence between two dates
suppose i have an product name as A001234-01APR10 which expires after 5
business days that is on 07th apr.. so It should give, on 3rd apr what is its
age and on 8th showing as expired..
what will be the excel based formula for this...
I'll give you the main tool.
In order to calculate the working days (Mon-Thu) between two dates use:
=NETWORKDAYS(A1,A2) [where A1 has earliest date, B1 has latest date]
I would suggest to use this function - with an appropriate check - to
declare Conditional Format in coloring the cell when Expired.
Same Function can be used to present the &quo...Office 11
I was recommended by John McGhie (MVP) to wait for Office
11 instead of getting Offixe X now. Can anyone tell me
then, when Office 11 is due?
In article <email@example.com>,
"Annick C." <firstname.lastname@example.org> wrote:
> I was recommended by John McGhie (MVP) to wait for Office
> 11 instead of getting Offixe X now. Can anyone tell me
> then, when Office 11 is due?
AFAIK, MS has not released an expected date for Office 11. As usual,
until it's officially announced, those that know can't tell you, and
those that tell you alm...Why does OWA...
When I bring up OWA, it asks me for my authentication twice in a row. The
first one appears to be just logging onto the server and the second one
seems to be logging into Exchange. I really don't know exactly.
The first authentication box says "Site: mydomain.com"
The second authentication box says "Site: server.mydomain.com"
Is this normal?
I am creating a template which requires the user enter a time (not
present time, flight times), for example the user will be listing a
number of flight arrivals and departures and what I want to do is have
the user simply enter something like 804p and have the cell display it
as 8:04 pm. I have looked at some custom formats and nothing seems to
be able to do this. Any help would be appreciated.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
http:...OWA premium 2003 prompts for office CD?
This is a multi-part message in MIME format.
I have seen on a few machines that while using the Premium version the =
computer will bring up prompts to insert the office CD to install =
something. But what confuses me is that I've tried OWA2003 on a machine =
without office and it works fine, so it appears to not require MS office =
unless you have office installed and then it prompts the user multiple =
times to insert the office CD.
Can any...OWA requires second authentication if mailbox is not on OWA server
I have 2 exchange 2000/W2K boxes, and 1 exchange 2003/W2K3 box in my
enterprise. I have just added a second exchange 2003 SP2/W2K3 box
which will replace one of my exchange 2000 boxes. All 3 servers are
back end servers and house mailbox stores.
The box I am replacing is also the OWA server. When I use my new
server to open a mailbox through OWA that is in the mailbox store on
the same (new E2K3SP2) server I log in without any issues.
If, however, the mailbox resides in the mail store on my previously
existing Exchange 2003 mail server, I am prompted to enter my login
credentials twice. ...how do I import my address file when they are an ldif format?
"Curtis Buck" <email@example.com> wrote in message
I always hate replying with just a url, but,
http://www.slipstick.com/config/convaddr.htm should have the answer you
need. Looks like there are a few different options, including finding
something to convert from LDIF to CSV and then importing into Outlook.
And, as a side note, it's generally a good idea to actually put the question
as part of the message, including information about the environment, like
version of outlook, what sort of mail server yo...OWA setup #4
I have a front end server on the inside network on the same subnet as my
backend server. Do I need to do anything special to have the front
communicate with the backend server..other then check the front end server
box. I did all of the basics already. I am going to deploy an isa server in
our dmz but for now I need to make this work. I can get the front ot work but
it won;t work using premium mode on the logon screen but it will work using
the backend server as the owa server even though I am attemping to login to
it from the same server(front end)
There shouldn't be anything spec...Formatting a 4 Series Stock Chart
The line in my 4 series stock chart is positioned behind the bar, thus
partially hidden. Is there any way I can make the bar semi-transparent or
move the line to the front of the bar?
...OWA down again
We rebooted the Windows 2000 server. Now when we try to
access OWA, after the log on screen we get the error
page ""HTTP/1.1 503 Service Unavailable". IIS 5 was
restarted but we still get this error. I tried to create
another virtual HTTP server in Exchange to make another
web site but again we get the "HTTP/1.1 503 Service
Unavailable". Do you know what we can do to fix this?
...No date and time displayed
I am having a problem with the outlook. There are no date
and time displayed on all my emails. When I received an
email I should see date and time in the Received colume,
but it's not there. Also, when I was trying to use the
Calendar, date and time are not there too. I have updated
my Outlook 2002 with SP-2. Can any one help?
...OWA not displaying mailboxes
Hi .I setup a new windows 3K server, move AD on it and install exchange 2003
with SP2, test it and seems to me that everything was working. Then delete
exchange from the old domain controller and removed AD but now when I run OWA
no mailboxes appear. I just have some little boxes for the pictures and
Loading... on the second frame.
Any help is welcome. I already tried to reinstall exchange and reapply SP2
but that didn't help.
On Fri, 30 Dec 2005 06:47:02 -0800, O Rako <O
>Hi .I setup a new windows 3K server, move AD on...