Greater Than / Less Than Problem
Don't want to sound silly here, but I am actually having a problem with
a formula that will allow me to count only values greater than 0 but
less than 11. Is this Possible in 1 unique formula? Heres the
situation:
Within Column B6:B35, I want a count of any number that is greater
than 0 but less than 11. I tried the following but it returns a 0:
countif(B6:B35,">0<11")
Thanks In Advance for any help here...
--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php?action=getinfo&us...
Outlook Mobile Access ProblemHi I've a big problem in Outlook Mobile Access.
I've a server exchange standalone withoput a front-end=20
one...
I've configured the OWA web form authentication and SSL.
For OWA it's all right...everything is going right...
The problem is OMA
When I try to log on on oma I find the following error=20
message :"Unable to connect to your mailbox"
To solve my problem I've found in microsoft web site the=20
following link
Microsoft Knowledge Base - 817379
Cannot Access Exchange Server 2003 by Using Outlook Mobile=20
Access When the
Exchange Virtual Directory Require...
Linking a graph to a csv file**Excel 2002
Hello, I'm sure this is exceedingly easy, but somehow,
I'm screwing this up. I ultimately need to have a self-
updating PowerPoint file (client mandates a ppt file).
According to ppt's help, that means I have to use linked
Excel graphs, not embedded ppt graphs. However, my
programmer will be supplying me with tons of csv files.
When I try to create an excel file with a data link to a
csv file, it tells me that it can't update it unless I
open the source file. I *can't* take the time to open
each csv - there will be hundreds. What am I missing
wi...
Outlook2k7 over VPN Out of Office Assistant problemUser's computer is not a member of the domain. Mail flows and all
looks good till you start the OOF thing. It will just tell you it
cannot connect to the server because it's currently unavailable. Now
when we add autodiscover.domain.com pointing to the Exchange server to
the host file of that computer it works but why? Without it when you
run a test it will tell you that a Srv Record lookup for domain.com
FAILED (0x8004010F) or Local autodiscover for domain.com FAILED
(0x8004010F)
yaro
Hello yaro,
Thanks for your post.
The error 0x8004010F usually means MAPI_E_NOT_FOU...
Quirky recent file list #2
Debra---
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
Stacie
--
SPenney
------------------------------------------------------------------------
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
changed. <g>
If/when you upgr...
Importing Data into an Excel Pivot Table via AccessI have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...
problem with signatureI am trying to create a simple signature for my HTML mails, with a link to
my website.I want it to be a hover link, no underline.
I have made a very simple HTML in Dreamweaver, and all the appropriate
attributes and styles are set via CSS. It looks and works fine on my
browser.
But when I select it as my signature file in OL2003, hover link property
disappears and it reverts to the dreaded underline link.
Any ideas how achieve this?
TIA
...
Illegal operation error while printing EXCEL or WORD FilesHi,
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
networked printer.
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...
Office:mac v.X #2Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I have subject version of Office. I know that there must be updates to this so I can bring this up to date but I can seem to find the ones I need to start the process. Can someone get me to the beginning? Thanks!!!
You can get the Office X 10.1.9 update here:
http://snipurl.com/22zx4
On 3/30/08 3:09 PM, in article ee96b4c.-1@webcrossing.caR9absDaxw,
"AWOLGolfer@officeformac.com" <AWOLGolfer@officeformac.com> wrote:
> Version: v.X
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
&g...
outlook 2000 help fileSeems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...
Import Palm filesCan anyone help me by telling me how to import palm files
(dat files) into outlook. I want to import contact,
calendar, etc
Depends what you can export to from Palm Desktop. Personally, I've found
this messy. Why not just get sync software that can sync your Palm with
Outlook directly? Chapura Pocketmirror or Pumatech Intellisync are two
ideas....or your Palm CD may have come with this option.
F. Carvalho wrote:
> Can anyone help me by telling me how to import palm files
> (dat files) into outlook. I want to import contact,
> calendar, etc
...
Installing office 2000 disk 2 with publisher on upgraded windows xI can not get disk 2 to install. It preloads then as files start to copy, it stalls then ends with error message. this is office2000 professional 2 cd set.
everything else works exept publisher and its components.
Please advise
Thanks
What is the error message?
--
JoAnn Paules
MVP Microsoft [Publisher]
"cugolfn" <cugolfn@discussions.microsoft.com> wrote in message
news:F57B8716-65FA-4619-93A4-AA24D44ABC33@microsoft.com...
>I can not get disk 2 to install. It preloads then as files start to copy,
>it stalls then ends with error message. this is office2000 profess...
Office XP to Office 2004 QuestionHi,
I am sure this question has been asked many times, but I've never had
occasion to look at Mac NGs before, so please accept my apologies.
I am a Windows XP user who is contemplating the change to a Mac. I have
Office XP Pro installed on my Windows machine, and I accept that I'll
need to get the Mac Office (Office 2004?) when I change over.
I understand that Word, Excel & Powerpoint files should migrate in a
fairly straightforward manner, but I am less sure about Outlook to
Entourage. (I'm assuming here that Entourage is the Mac 'equivalent' of
Outlook?)
I h...
List Shows Private FilesDID ANYONE ELSE NOTICE THIS?
Whenever I save an attachment, and go to the drop down
menu for file name, I am shown a list of dozens of files
recently accessed on the computer (not just files
accessed by Outlook Express). This occurs even if recent
cocuments is turned off in Windows XP and even if the
recent documents folder for Windows XP has been cleared.
This shows too much! Others using Outlook Express on the
same computer can potentially view the file names of
every document, image, and device recently accessed.
Where is the folder to clear this data out of?
duncan <anonym...
Memory Usage When Playing WMV HD FilesHi all,
When I watch a WMV HD file using WMP11, the file appears to start up and
play well until I try to fast forward / jump to another part of the file,
then the player just stops and after watching via the task manager, WMP
memory usage goes through the roof ie. gigabytes and ultimately the player
crashes.
Have reinstalled the player, have tried various codecs etc but all appears
to be unsuccessful. System is XP based, E6600 cpu with 4gb PC6400 memory and
8800GTS 640mb graphics. Any help would be much appreciated.
Thanks in advance.
Dumb question: what video card d...
To increase the upload file limit ONLY for one site collectionHi,
I have more than 1900 site collections on a web application. I know I can
modify the upload file limit thru the CA or directly on the Web config file.
However, I do not want to change the setting for all the site collections. I
need to be able to change the setting only for a particular site collection.
Is there anyway I can add manualy that entry in the web config file. Has
anyone tried? Is this possible?
Thanks in advance,
Antonio
...
Debugger comes up when attaching files to Outlook 2002I have a pro bono non-profit client running win xp sp3 & ms office pro.
Last week she reported that every time she tried to attach a file to an
outlook email, she received a dialog asking her if she wanted to start
the debugger. It never allows her to attach the file and if she goes
through with starting the debugger, she gets a variety of errors...
never a repeating error.
Anyone have any experience with this error?
Michael
...
How to realize communication problem?Hello everybody.
I am working on a project in which I read/write data via rs-232 from/to my
Windows application to/from an microcontroller.
Now, my boss wants me to write a library which he can use for different
microcontrollers. This library should store any changes of data. So the
desired microcontroller should just be able to pick up the data.
You can think of it this way: Me, representing the Windows application, put
a sheet of information into a drawer. A buddy of mine, (representing a
microcontroller) can go to the drawer an pick up the sheet for further
treatment.
So, my quest...
Office 2007 Compatibility Pack 12-10-09My new Windows 7 laptop came with a trial version of Office 2007 (Student),
which I uninstalled prior to first use. However, I have the PowerPoint
Viewer installed, which I use. Question: There's a huge 173 MB Office
Compatibility Pack in the Control Panel, Programs and Features, which can be
uninstalled. Can I uninstall this without any effect on the PowerPoint
Viewer or Microsoft Works (or Windows Live Mail) programs? Thanks.
EW
Hi, Lone Star,
The compatibility pack is actually quite useful if you are running a
previous version of Office. Are you only using W...
OWA problems #6Users from outside the firewall can logon succesfully into OWA interface,
their mailbox opens, but in the reading pane the only message is "loading..."
Also no other functions of OWA interface seems to work (new, contacts...) as
well as log off button.
However if I try to access OWA from inside the company everything is fine.
Windows 2000 Server SP4
Exchange 2003 SP1
On Thu, 6 Oct 2005 11:33:14 -0700, "Ducukm0"
<Ducukm0@discussions.microsoft.com> wrote:
>Users from outside the firewall can logon succesfully into OWA interface,
>their mailbox opens, but in t...
file sbolext.dllDownloaded a program some time ago that I found had
spyware in it.When I took out the programs I started
getting error message at start up of Outlook. "file
hotbar\bin\448~1.o\sbolext.dll missing" Downloaded from
Microsoft the newest version of the file. Still getting
the error message on start. The program runs fine, don't
know why it is looking for this file. Running Office 2000
Sr-1. The program removed was hot bars for wall paper and
scam mail. Any help would be appreciated.
Thank you. e-mail address is jvanwie@tampabay.rr.com.
...
Test Drive Office v.X won't install on OS XHi, I have a new mac - and can't get this Office X demo to install. Has
anyone had a problem with installing the test drive version of Office v.X
stating that "it can't install on read only volume" - If so - how to do I
solve that problem
...
popup box message; "Publisher cannot open the file"saved as a .pub file but unable to open. popup box message "Publisher cannot
open the file"
What version Publisher do you have? Do you know what version Publisher was used to
create the file?
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"stature" <stature@discussions.microsoft.com> wrote in message
news:0AD1D565-743D-478D-95DD-5C5358400272@microsoft.com...
> saved as a .pub file but unable to open. popup box message "Publisher cannot
> open the file"
...
i renamed a file i needed and lost the info how do i get it back?I had 2 files with the same name in excel. After I excited excel, I wanted to
rename my new file, and I thought I was renaming the new file, but I actually
renamed the old file I was working in and when it said this file exists do
you want to change I said yes. I lost all my work. How do I get it back?
You can't unless you had a backup. Not nice to excite excel.
--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Tera" <Tera@discussions.microsoft.com> wrote in message
news:6545DD51-3597-45DB-A187-F248ED970C8F@microsoft.com...
>I had 2 files with the same n...
Problems getting to server?I have a customer who is saying that if he tries to get
to a email server I am running, he can't get to it on the
1st attempt using Outlook Express. He has to browse to a
web page that I am hosting, view that page. Then open
OE, and his email will work fine.
Has anyone heard of this, and have any solutions?
Thanks,
Steve
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
family.
Here is the link for the right forum
http://communities.microsoft.com/newsgroups/default.asp?icp=Internet...