Excel template issues
I have a user that has a excel template on his network home dir
NW 5.1 Server
he says that after he creates a new file from that template - he goes to
open and it tells him read only access
running Excel 2000
...Outlook Desktop Client 4.0 issue
While installing the Outlook Client .net failed to install. Can't seem to
get pass the error. Does any one know what the issue might be. The machine
is an IBM Thinkpad T43. I'm also having issues with Outlook restarting
itself every five minutes on other machines after the client has been
download the .Netframework locally from google and install it and then
run the setup.
...Migrating XCHNG 5.5 to 2K3...ADC Issue
I'm in the process of testing the migration of an XCHNG 5.5 (NT 4 domain) to
an XCHNG 2K3 server (W2K member server) in a W2K3 AD domain.
I'm running the latest deployment tools (06.05.7226)...
I have just installed the ADC connector and I'm running the ADC tools as the
Exchange server admin (member of AD domain admins and place in org, site,
configuration container of XCHNG 5.5 with Service Account Admin
All mailbox users have been migrated already to AD domain...with one-to-one
Issue: When I run the ADC tool Data Collection (Step #2), it does not ...Gmail & Microsoft Outlook Issue
I'm experiencing a problem to retrieve email from Gmail on Microsoft Outlook
I set everything the way Gmail recomends it... turning on the SSL
authentication for both SMTP and POP3 servers.. using ports 995 and 465
(respectively)... activating the SMTP verification for outgoing mail and
when I push on the "Test Account Settings" everything is alright: it finds
the outgoing mail server, the incoming mail server, it logs onto the
incoming mail server BUT (huge big) it's unable to send a test message
e-mail... How is that possible ??? It sends the follow...Office XP Exel
Scenario: User's A,B, C, and D all have access to an excel XLS on a 2003
server. Users A & B have modify rights, users C&D only have read rights. If
user A updates the file, the general tab in properties reflect the exact
time the file was modified. After user A saves and closes the file, user D
goes in. The changes are there, but in the properties general tab, the
modify date in an old date (probably the actual creation date). Is this
normal ? Any idea's ?
...Issues with facebook...
Whenever I use any app on facebook, it says "I'm not logged in to do that"
and then I have to re log in. Is there some kind of issue I'm missing here?
I've got the Firefox 3.5.3 browser, I have f/b store my password so I DON'T
have to constantly log in to everything.
Can anyone help?!?
Please note that your problem has nothing to do with Windows XP. You should
contact Facebook administrators or post your query on Mozilla newsgroups.
Hope this helps. Sorry we can't help you here.
"spookyginger" <spookyginger@discussion...The Sum from 1 worksheet cell to another worksheet cell
the sum from one cell on sheet1 from another cell on sheet2,how do you do the formula
To sum the value on Sheet1, cell A10 with the cell
value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20
(or you can enter '=' sign and click on A10, then enter
the plus sign and click on B20)
>the sum from one cell on sheet1 from another cell on
sheet2,how do you do the formula
...Summing in A Query
I have a database which fuel records are stored in. The data is
stored in two tables. The first records the daily logs that operators
use each time they fuel up. It stores their name, the key they used
(keylock fuel system - it's ancient) the unit number of the equipment
using the fuel, and the amount of fuel they took. The second table
stores the month end information retrieved from the key lock print
out. It keeps a running total of the amount of fuel taken with each
key, and the operator using that key.
We have problems making sure all of the fuel is accounted for each
mon...Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value.
Have a look at this thread for something similar:
> I have a list of data and would like to know if there is a formula that would
> return any items from that list that sum to a known value.
...Public folder issue, "messaging interface has returned an unknown error"
I'm running a SBS2003 domain and just added a public folder and a
customized form for entry into the public folder. All of our clients
(all XP Pro, Outlook 2003 with all updates) can get to that folder and
use the form without any difficulty except for one. On one computer I
get the classic "The messaging interface has returned an unknown error.
If the problem persists, restart Outlook." error message.
I have tried a repair install, no change.
I have tried making a new profile, no change.
I have tried adding / removing his PST file (currently he's not even
using a pst file...Strange issue with OWA not displaying correctly.
Working on a Exchange 2003 sp1 server. When OWA is launched and the
credentials are entered, the next screen looks almost like a "FTP" site!
Any ideas where to start looking?
Do you have the Directory Browsing option selected on the default web site
(and hence the Exchange virtual directories under it)?
For Exchange news, links, and tips, check:
"Pete" <Pete@discussions.microsoft.com> wrote in message
> Working on a Exc...Issue with Loan Accounts
I have been having this issue for a while - but just now trying to figure
out what's happening. I have several loans (including car, equity, etc.)
which I have set up on Money 7. Sometimes the interest and principle are
calculated correctly - but more often, the entire sum of the payment is
allocated to principle (as viewed in the account register). I've check to
insure that the loan is set up okay - and it looks okay to me. Any ideas
what's happening to me?
Any help appreciated. Thanks. Patrick
I was really hoping someone would respond to this. My ...Excel Tends to access network when I issue commands
Excel on my PC usually access network when I issue the first command (or
after stopping activities on Excel for a while).
My system will "freeze" and I see the LAN icon on system tray light up -
indicating the PC is communicating with the LAN server.
Is this due to some macro or other options that I have previously chosen ?
This sometimes happens when I am working on my powerpoint.
Can Excel and PowerPoint work properly without doing this "freeze" and
communicating with server ? It is taking up time and my patience !!
...SUM help please
I have created a sheet which is tracking 3 items per client and a number
of clients so I have set up a SUM function the only way I know how which
is a long a1+a4+a7, etc
Its works fine, but if I want to add a new client and 3 new rows, ALL of
the + after are now off.
Is there a better way to create a formula that will track say every 3rd
cell in a column but then let you lengthen or shorten the column?
In searching her I have figured out it is the DSUM function that I ma
needing. I have tried a number of times - seems simple enough but I cant
get it to work
...Terminal Servers in Cluster - Login/Profile Issues
Currently I am having an issue with logins and profiles as per details
Server/Network Configuration Details:
1 X Windows Server 2008 Std FE 64bit (DC)
2 X Windows Server 2008 Ent 32bit Terminal Servers
User Profiles are Roaming and exist in: \\SBSERVER\Profiles on the Domain
Controller and C:\Users\ on the Terminal Servers.
Approx 50 users.
Error messages when logging in the terminal servers: Your roaming profile is
not synchronized correctly with the server. Windows will load your
previously-saved local profile instead. See the pre...Multiple Language Issues
Has anyone successfully manually updated a non-English supported 5.5 to
2003? (The reason for the manual update was a broken admin account.)
Mail and contacts were all exported to PST files, and then imported to 2003.
However, although the text of the messages is fine (English and Russian),
the text for contact names and message subjects gets gorched if they
contained any Russian text.
Does anyone know the correct sequence to follow to take messages and
contacts in Russian (or other languages) from 5.5 to 2003, while retaining
the non-English subject lines and contact names?
I just live in January, most of thing are good, but I have a big trouble
now. As GP provide very little function on Credit tracking, I lost the
function of tracking credit issued against item.( Such as warranty item, or
show room display item) Meanwhile, I didn't find any user defined area,
comment area or enough space to put more inforamtion about the credit on the
GP credit. Customer will don't know what the credit is for. It is just
If GP could allow crredit be issued through SOP with no return or on other
type of item, and link to GL automatically by changing...Outlook 2007 scrolling issue
I am running Outlook 2007 on Windows Vista Home Premium. My problem is
jerky scrolling in my inbox and in email messages. I am running this on a
laptop and have updated the driver for my touchpad. Any suggestions on how
I can get this to stop? Before 2007, I ran 2003 with no scrolling issues.
Thanks in advance for any help offered.
I have four fields on a form to show time. I want a seprate "Total" field to
add the time between the first two fields and then add the time between the
second two fields. Like this:
In LunchOut LunchIn Out
6:00am 12:00pm 12:30pm 4:30pm
The first four fields are stored as medium times. Can someone let me know
how to do this?
Message posted via AccessMonster.com
"ladybug via AccessMonster.com&quo...Sum only positive values
In my table the values can be positive or negative. I'm trying to do a
consult to sum only the positive values... How can I do it?
Thanks in advance!
Add the field to the query once more, remove the show flag & enter the
SELECT Sum(MyFieldd) AS TheSum
Where MyField >0
<firstname.lastname@example.org> wrote in message
In my table the values can be positive or negative. I'm trying to do a
consult to sum only the positive values... How can I do i...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....Help Please in Summing
Sorry to ask such a simple question, but I need help on
how to get a total of some cells.
Here's the sample.
A1 is 05 and is true
A3 is 10 and is true
A5 is 15 and is False
A7 is 10 and is True
A9 is 05 and is False
How can I make A11 show me the result by just adding those
numbers that are TRUE and give me the sum ?
Would really like help, thank you.
I assume that you have TRUE or FALSE as boolean in an adjacent cell.
But the assumption may be wrong and you'll need to provide more
Regard...Gift Voucher issues
We just had (yet another)POS crash when trying to tender a sale.
Normally we can make the adjustment for cash/credit/debit at closing
but this time it was on a Gift Certificate and the system doesn't grok
that and even though it shows the items as sold, it did not subtract
the sale from the GC and now shows the GC balance as 164.54 higher
than it should be.
Also I just realized that Gift Certificates seem to be double entering
in Sales, as Sales includes the GC being sold initially AND then again
when the GC is used. Meaning that our Total Sales Volume could be
thousands of $$$ off.
Any ...Calendar issue?
I have a user who's outlook locks up while accepting a
meeting request. We have Exchange 5.5 server. He is
currently using Office XP (so Outlook 2002) but we also
tested by putting his email profile on another PC with
outlook 2000 on it (like most of the rest of the users)
with the same result. This only happens when dealing with
meeting requests. After either outlook is terminated or
the request finally goes through (sometimes taking 40-50
minutes), things work pretty much normally. He may have
to exit and go back into outlook to work in the calendar
OK. It is only for thi...Money 2005 Password Issue
I have been using Money 2005 for about 8 months and suddenly I cannot sign in
using my usual hotmail.com passport. The error message is "the e-mail address
or password is incorrect". However, I can sign in using the same e-mail
address/password pair to hotmail and MSN Money in IE.
I've tried KB Q331123 but no luck.
1) I can get into my Money file in offline mode
2) I even tried to change passport password. The new password works in IE,
but not Money.
> I have been using Money 2005 for about 8 months and suddenly I cannot...