Excel 95 user need help
Buying newer version is not an option.
I try to open excel files and it says...not a valid file format.
Searched updates and downloads for a converter or somethint to open new
versions but I cannot find anything that works...tried the SP3 for xp said
did not find expected version and quit. Cannot get compatibility 2002 to
Am I up the river on this or is there something...some update that will help?
Excel (and its file formats) has come a long way since Excel '95 ... It's been unsupported now for quite some years.
[Mic...Need help with query summing hours
Tring to get total worked hours and total maintenance hours summary.
I have a table with the clock hours
And have a maintenace table
Needing help combining the information to get summary something like this..
Date - Employee - Clock Hours - Maintenance Hours
1/1/10 Joe Billy Bob 8 6
1/1/10 Billy Joe Bob 8 7
Whay type of query do I need to build, any help would be great.
Message posted via http://www.accessmo...ive got dots in my wedding invitations on the corners help
in publisher i have dots in the corner of the invitations. i would like to
remove them if someone can tell me how i would appreciate it thanks jim
Send me the file (and tell me which version of Publisher you are using).
We'll see if they are really there or if you've already popped the seal on
that champagne. ;-)
MVP Microsoft [Publisher]
"tarheel jim" <tarheel email@example.com> wrote in message
> in publisher i have dots in the corner of the invitations. i wo...Simple question about weird behavior of the HELP window in Excel
Operating System: Mac OS X 10.5 (Leopard)
Whenever I click on the Excel Help item on the Help menu in Excel,
a help window appears in a fixed position, on top of all other windows, with no CLOSE button...! There are some button across the top, left and right arrows, a HOME button, Search, Contents, Index, etc. but no close button.
I can find no reliable way to make the Help window disappear!
I say "reliable" because sometimes (not always) Command-W will make it disappear; other times Command-W will only make my current Excel file window close.
How ...FORMULA HELP! Find all values in column at random rows and perform calcutlation.
1000 Total of formula here.
I don't know what row a % number will show up on col A but it is before row
1000. I would like row 1000 under column A to have a formula that says
look for any row in column A and if you find a number, add 1 to that number
and then find the next one and add 1 to that number and then multiply those
two together and then find the next one add 1 then multiply to the last
Bascially, A100 would have the formula (1+A3)*(1+A6)*(1+A9)*(1+A12)...e...1.2 Integration and GP 7.5
Does 1.2 CRM Integration work with Great Plains 7.5? The Integration
install guide says 7.0, but I would assume it would work with the latest
version of GP.
Presentations Direct - Office Equipment & Supplies
Where did you get hold of the 1.2 Integration appliication? I can only see
1.0 Integration avail at the moment
"Brandon S." <firstname.lastname@example.org> wrote in message
> Does 1.2 CRM Integration work with Great Plains 7.5? The Inte...help plz
I have a column with numbers, I have to generate a formula usinfg a if
statement, that if its divisible by 3 than it should answer true, otherwise
"zomex" <email@example.com> wrote in message
>I have a column with numbers, I have to generate a formula usinfg a if
> statement, that if its divisible by 3 than it should answer true,
...Need help with a function
I'm sorry but I'm not too much familiar with Excel. I have some listing in
in A1 I have:
in A2 I have:
in A3 I have:
I want the word between the 2nd and 3rd '\' to be in color red. So in A1
folder1 should be in red, in A2 folder2 in red etc
I could do it manually but there are like 3000 lines. It would take forever.
Is this simple to achieve with a script/macro/? ? I hope someone can help me.
Thanks in advance.
Presumably you want to pick that value o...Exchange 5.5 system attendant service hangs
Here is the situation store.exe was taking 100% of
resources I rebooted the server and when it came back up
the system attendant was hung on starting.I have also
noticed when i login with the domain admin account i
cannot access the app and system log in event viewer as
well as exchange administrator i get access denied on all
3 i have ran esutil and mtacheck with everything seeming
ok this is a exchange 5.5 with all updates and nt 4.0
server with all updates. A little info i can login as
local admin and can open all 3 but when i open exchange
administrator it can not find the exchan...Need help with a simple Time calculation
I'm a little new in Excel, I need some help
with at sheet, that are able to calculate time
something like this:
text1 3:30 (3 min 30 sec)
text2 2:10 3:40 (result of text1 and test2)
text3 1:40 8:20 (result of text1, 2 and 3)
Thanks in advance
if the fields have times in them as they appear, just add them like any
other cells and format as mm:ss or hh:mm:ss
"Bjarne Hansen" <firstname.lastname@example.org> wrote in message
> ...Can anyone help with this problem? bug?
I installed MYIE2 (www.myie2.com) and chose it to be default browser, when
I reverted back to IE as default browser it affected one thing I know in
on the toolbar, when you open up a contact, theres a "road sign button" to
the right of the "red flag" I get this error, when i click on it:
"This file does not have a program associated with it for performing this
action. Crate an assocition in the Folder Options control panel"
I dont know what association to go to in Folder options and uninstalling
outlook and reinstalling it did not fix the problem no...Migration to Exchange 2003 #2
I have just built a new exchage 2003 server which is now part of our
windows 2k domain currently running exchange 2k.
All is well with the installation and upgrade of AD to suit the new 03
box. My problem is with the migration.
On the new exchange box i ran the Migration wizard to import the user
accounts, however when i specify the servers sourse and destination i
get a warning:
Please enter a source Exchange server outside of the organization.
Unable to perform migration..... ????
I am now taking the route of exporting all the mail boxes to .pst's
then doing an import with exmerge!!...How to connect 2 sites using Exchange 5.5
I have 2 Exhanges runing in a diferent subnets.
Yesterday everything was working fine, but now I can not
send a email between sites. What can I do?
...integrate web page form with sql and crm
Is it possible to edit the "case" form using front Page.
If so how do i set it up to access the sql database.
These forms are not designed to be edited in frontpage.
"Dana" <email@example.com> wrote in message
> Is it possible to edit the "case" form using front Page.
> If so how do i set it up to access the sql database.
...OWA SSL problem... please help
Hi, We have an Exchange Server with OWA on SSL.
2 Days ago something happened to the SSL on IIS. On accessing the
https://mailserveraddress/exchange website the certificate or login prompts
do not appear. Instead I get a "page cannot be displayed" error. When SSL is
disabled (http://mailserveraddress/exchange) OWA works just fine.
I have tried everything I could find on MS KB with little success. Does
somebody know how to resolve this problem and get Certificate Services back
up on IIS ?
Thank you for your help
...Exchange partion size sbs2003 vs sbs2008
I know there is no "right " answere on this, but I need a feel for realative
needs of exchange 07 vs 03.
1. I understand that a 3 partition minimum setup is still suggested on
SBS2008 I.E. os/exchange/everything esle.
2. This customer has a 50 gig Exchange partition on SBS2003 and in 3 years
has only used 10 gig of it. In the move to SBS2008 with Exchange2007 will the
50gig partition still be ok, or will 07 take up considerably more room?
This is a multi-part message in MIME format.
charset=&q...Previewing the pages to be printed from a help topic
I need help on the above subject.just to know the number of pages to be printed in order not to be out of paper
I have window XP professional
it does not work either oe EXCEL2002 and/or WORD200
many thanks in advanc
the best idea i have is to print to a PDF document (if you have a PDF
printer driver installed). Otherwise not possible with build-in
> I need help on the above subject.just to know the number of pages to
> be printed in order not to be out of paper. I have windo...Help with a formula (Multiple lines to sum and return if)
Thank you in advance for the help. One sheet one I would like to return the
sum of data from sheet two if the salesperson name matches. Here are the
In column A I have the names of sales people (listed by row) - header is
In column B I have cells available to total the sales people numbers by month
In column A, the sales people are listed many times
In column B, lists the Account name (not important for this help)
In column C, is the total sold to that customer
Now in the B column, I would like to match the name of the ...HELP The program is in a invalid format, and cannot be run
"The program is in a invalid format, and cannot
be run. It may be damaged" when I try to run it on Win98".
I'm using VC 2003 with MFC.
check Unicode / MBCS , Win98 should use MBCS.
"fba" <firstname.lastname@example.org> wrote in message
> "The program is in a invalid format, and cannot
> be run. It may be damaged" when I try to run it on Win98".
> I'm using VC 2003 with MFC.
> "The program is in a invalid format, a...Outlook 2003 loses connection to Exchange 2003
We are experiencing delays with outlook 2003 connecting to exchange 2003.
I have received numerous conplains from my clients taking 2-10 minutes for
their outlook to re-connect to exchange expecially when switching between
There has been times some users conplained it took up to 25 minutes with the
"retrieving message from exchange" popup runing to just retrieve mssages.
My testing have ruled out all network related issues and seem to narrow it
down to outlook 2003.
We are not using cache mode.
Has anyone seen this problem and have any solution?
...Exchange 2003 run database defragment show [Out of database page buffers]
run eseutil/p command on yesterday,
after less than 24 hours, we found the error
message "Operation terminated with error -1014
(JET_errorOut ofBuffer, Out of database page buffers)
after 847,402.35 seconds" appear.
Anyone know of a report I can generate, or a log that I can view, regularly
which shows me what types of attachments users are emailing off of the
network to external email addresses?
Nothing native/built-in. Don't see a specific attachment report in the
following 3rd party products, but these are otherwise known to be the go-to
tools for reporting on Exchange traffic and usage:
Quest Message Stats:
MVP - Exchange
www.zenprise.com...Help-Updating from a Web File Download to a Direct Download in '05
I am using Money 2005 and my financial institution just went from web
downloads of files to Direct downloads where I can enter my id and password
in Money. Is there a way to disable my existing account and have the direct
download take over that does not require me to have the new direct download
be a new account and then use the Merge feature? I was hoping I could
disconnect and reconnect. Has this process changed for 2006 or 2007?
...Help with MS word
Can someone help me with the following:
- Adding fields to document properties so that it can be easily retrieved
from share point
- Populating these document property fields in the document such that when
the values in the document property are changed the word document updates
- Getting images list in the 'Table of contents' page of the document
- Getting the external references in the 'Table of contents' of the document
- Preparing the template such that when the base template is updated,
documents based on this template within the sharepoint are updated ...Please anyone can help? Right/Left hand expanding & dropdown embarrassing in open random places
Since 2 days ago (never happened for years) I am having a non-critical, but
kind of annoying issue.
My left hand keeps jerking up and down and my right hand keeps rubbing left
A typical male multiple-yanking choice , e..g. right/left-expanding or
dropdown; for example try right-click on empty member area and select View
or SortBy, which in turn
also leads to other private matters. Or in bed by myself, click
zoom, etc. Or any other expanding type of embarrassing venture seems to
overwhelm the natives.
Well, upto today it was predictable - ...