Click in cell w/ formula and get colors in referenced cells
When you click in a cell with a formula, Excel will then put color
around the cells that are referenced.
Somehow I turned that feature off. Now I do not get colors in th
other cells. Where is that option to turn it back on???? I've looke
and looked but I just can't find that option.
Thanks for the help
albean's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2875
View this thread: http://www.excelforum.com/showthread.php?threadid=48436
...how can I type up a consent form
I need to make one because my son is going out of state with his grandmother
and I need to get one made up fast so that if anything goes wrong she can
sign for him at the E.R.
Hardly an excel problem.
"Danie" <Danie@discussions.microsoft.com> wrote in message
>I need to make one because my son is going out of state with his
> and I need to get one made up fast so that if anything goes wrong she can
> sign for him at the E.R.
W...Hiding OLD customers in list
I have a customer list (tblCustomers)
And an Orders table (tblOrders)
I want to have an admin area functionality that prunes (hides from display
in any list or report) Customers from the list that have not placed an order
in X number of days (Admin can enter the number of days in a text box)
Solution does not have to be in days or in a text box. Could be several
check boxes (30 days, 10 weeks, 2 years...).
I am just looking for the simplest solution for us to limit the Customer
list by last order date.
Any help here will be appreciated.
Thanks in advance
If it were me, I would have a ...How can I customize the Filter Drop down on the formatting toolbar
I want to clear everything out of it, except the customized filters I have
created. Can i do that?
Project > Filter by > More Filters, then select each one, Edit, and remove
the checkbox for Show in Menu.
- Andrew Lavinsky
> I want to clear everything out of it, except the customized filters I
> have created. Can i do that?
I've tried that - it doesn't affect that drop down filter list - whether they
are checked or not.
"Andrew Lavinsky" wrote:
> Project > Filter by > Mo...Getting Mailbox Sizes in 5.5
This is a multi-part message in MIME format.
Working on an Exchange 5.5 to 2K3 migration. Is there any easy way to =
get a list of mailboxes with their sizes from the Exchange 5.5 =
directory? I know I can use System Admin to see each server and then =
export the list, but is there a way to this, maybe with a script so I =
don't have to export the list from each server separately? Thanks.
Co...Upgrading to v3.0 & Utilizing a Test Server
I would like to be able to build a test environment to test upgrade a real
copy of our production CRM db (v1.2) and test the upgrade to v3.
I know the best way to build a test copy is a clean install of 1.2 and
migrate data and import our current schema. But that does not give me my
actual db in test, all it gives me is data and schema.
I want to be able to have a test db the mirrors production with all the
store procedures and triggers we have or may have in place. That way I know
really what will happen when I upgrade.
Is there a way to do this? I have a second domain that I can use...How do I get a scrollbar in a textfield
Is it possible to make a scrollbar in a textfield in publisher 2003. If the
answer is Yes, than my question is: How? If the answer is No, than can you
tell me if there is an alternative to show lots of text with use of an
> Is it possible to make a scrollbar in a textfield in publisher 2003. If the
> answer is Yes, than my question is: How? If the answer is No, than can you
> tell me if there is an alternative to show lots of text with use of an
Publisher is primarily designed for creating documents to be read on a
printed page. Obviousl...Getting rid of #DIV/0! #2
Does anybody know a quick way of getting rid of the error message
#DIV/0!. Like a way to change it into just 0 or something? Thanks
Here are some typical ways....
For values in A1 and B1
Different ways depending on your anticipated values....
Is that something you can work with?
> Does anybody know a quick way of getting rid of the error message
> #DIV/0!. Like a way to change it into just 0 or something? Than...MS CRM 3.0 Customer Case Problem
Dear CRM Experts,
I have a problem with MS CRM 3.0: I want to create a web based form in our
company website that customers create their Cases (tickets) by it and we (I
and my Tech. staff) response to them (Ticketing system).
It seems for security reasons we shouldn’t allow CRM browsing outside of our
Internal Network (Intranet).
Please help me how can present solution for this problem.
You have a couple of options. There are third-party apps that will let you
integrate CRM with your website, but with 3.0 you would probably need to
purchase the External C...MSCRM w/ SBS2k
If I have an existing domain, can I add SBS2k to the domain
as one of the domain's DC's?
Or do I have to create a new domain for SBS2k and trust it to my existing?
We would like to install MSCRM in our existing business network using SBS.
SBS will not allow you to create a trust with another Domain.
"Do" <email@example.com> wrote in message
If I have an existing domain, can I add SBS2k to the domain
as one of the domain's DC's?
Or do I have to create a new domain for SBS2k...Custom Reports Using MS Access?
Ran across a thread where Glen Adams suggested using MS
Access to create custom reports instead of Crystal
Reports. But Glenn never said where to point Access to
obtain the needed information to create the reports.
Glenn, if you are watching can you give us some more info
on how to use Access to create a report?
I'm not Glen...
I think you would use ODBC... to connect to the RMS database. Then use
Access to connect via ODBC...
"Dan" <firstname.lastname@example.org> wrote in message
&g...Newbie question, can't get a handle on the handles <g> ... ?
How do we manipulate text that needs to flow to another box, i.e.,
when working in two columns and we need text to flow to a third, how
do we do this?
I'm sorry for such a simple question, but I've looked through the help
and on the web and I think it's because I don't know what it's called.
Anyhoo, pls advise!
Whilst attempting to develop brick-based storage technology, Ed reads a
message from Dylan56 <No@SpamAtAll.com>
> How do we manipulate text that needs to flow to another box, i.e.,
> when working in two columns and we need text to flow to a third,...How to get http response after post
My pseudo code and question are folowing:
DWORD dwBuffLen = sizeof(dwStatus);
CString strHttpName = "http://www.eee.com/login.asp";
char opt = "UserName=uuu&Password=ppp";
CString strHeaders = "Content-Type: application/x-www-form-urlencoded\r\n";
CInternetSession session("IE 5.0");
session.GetHttpConnection("www.dailygraphs.com",0,INTERNET_DEFAULT...Customer (Pole) Display
I'm having a problem where Pole Display's on one customer site are dying one
by one. At first it starts flickering, then within a few days it dies
Has anyone else encountered a similar problem?
This may be an OPOS driver mismatch or wrong Baud Rate issue. Which PD model
and OPOS driver are you using?
Try to change the baud rate to others value first.
"trcboy" <email@example.com> wrote in message
> I'm having a problem where Pole Display's ...Slightly OT: Online print house for custom greeting/note cards
I somehow got "volunteered" (again) to create a few different designs for
notecard/greeting cards for a non-profit org. so they can sell them to
raise money. I'm looking for a cost effective online source (print house)
that can take uploads of my designs. 4 color face & folds etc.
I've looked at a few, but was wondering if anyone has any input
Can't help you - I use a local printer. Sorry.
MVP Microsoft [Publisher]
"Rob Giordano (Crash)" <firstname.lastname@example.org> wrote in message
news:%233wnw3P1...Purpose of Matrix Item Type
I have been using RMS for over a year, and have never used the matrix item
type, mainly because I do not want an unmanageable number of items. The last
POS system I used had sub item matrices for size, color, etc. It seems like
RMS just adds more items, right? If so, what is the purpose (usefullness?)
of matrices? Other than through a member of the matrix, how do you access
information about the matrix?
Here's and example of what I want to do. Shoe abc, with widths (M, W), and
sizes. Sometimes I care about item abc (sales reporting), and sometimes I
care about the mor...Formatting multiple object types in output from a function?
I'm stumped on this one, and have searched and searched for a solution
or how-to with no luck. Perhaps it just can't be done. I have a
function that may or may not return objects of multiple types. I've
setup the type and formatting information for each of the individual
types in format.ps1xml files, and when only 1 type is returned by the
function the formatting works as I would expect.
However, if two or more types are returned by the function, only the
formatting for the first object type is applied and then the other types
are displayed however PoSH deems ap...Custom Report 03-19-10
There is no way for me to run a report on Buydown Pricing, is there anyone
who has a report for this option?
If not, can someone write a custom report for it, and how much might
something like this run me?
I would like it to do something like buydown quantity greater/less/equal and
same for buydown price...
please contact me at nagarra @ yahoo . com or respond here with your contact
...Template driver code for a new USB Touchscreen XP driver
We want to develop a new Touchscreen driver having a USB interface for
Windows XP. Which driver template will be the most suitable to start the
make your device a HID and then you not have to write a driver at all.
This posting is provided "AS IS" with no warranties, and confers no rights.
"sanju_emb" <email@example.com> wrote in message
> We want to develop a new Touchscreen driver having a USB interface for
> Windows XP. Which driver te...can't get pc to hibernate
I have windows XP sp2, Sometimes in hibernation mode the shut down process
gets as far as "preparing to hibernate" and then the screen freezes. I then
have to use the on-off button to close the pc. Can anyone help in rectifying
this problem? I can copy the system information details to here if that will
Laurence, check out this Excellent Shutdown Troubleshooter
"laurence withau" <firstname.lastname@example.org> wrote in
message news:E97F9CA4-E8BA-41D3-81...Custom CommandBar gone
Using Access 2003
I created a custom commandbar and I was using it as the menu bar for
my main form. But it's not showing up anymore.
It's still a choice in the menu bar drop down field of the form's
It is not listed in the toolbar list when I right click on the default
menu bar and choose to customize. But if I click on the Properties
button on another toolbar, the next window has a drop down box for
Selected Toolbar. It is still listed as a choice here.
I've tried doing a Compact and Repair, but that didn't help anything.
Where did it go and can I get it ...Error code 57E
I have Vista 32 bit XP windows Home Premium. Try to install 2007 Microsoft
System KB972581 and Visio Viewer 2007 Service Pact 2, stalls at 50% install,
however any other updates are installed. I have turned off the firewall and
Microsoft Security Essentials and tried to install after, and still error
code 57E on these 2 updates.
The updates that did install are as follows...
Cumulative Security Active X Killbits
Microsoft Outlook 2007 Junk Mail Filter
Security Essentials for Microsoft Office
Windows Malicious Removal Tool
I had this problem before with the SP2 ...customizations import from 3.0 to 4.0
Is is possible to import customizations into a 4.0 system that were
exported from a 3.0 install?
You will need to upgrade 3.0 implementation to 4.0 by running MS CRM 4.0
setup. Please go through Microsoft Dynamics CRM 4.0 Installing Guide. You can
download this guide from folowing URL
I don't think that there is any supported way through which you can import
3.0 Customization file to 4.0 implementation.
> Is is possible to im...Adding Fields and Tables to MSCRM
Is there a link or some reference on the ability to add fields to existing
tables in the CRM database and/or adding complete tables to the CRM
database?? I am asking this from the point of view relating to other
existing CRM products (saleslogix, frontrange - shh). From what I have
played with so far from playing with my SBS2k/MSCRM install is I my need to
have a MS developer skillset.
Using the schema manager in the deployment Manager MMC snap-in, you can add
fields to the existing tables. However, there is no way to add new tables.
"Robb D" <robbd@eproductscons...custom errors in HRESULT
We have methods that all return HRESULT. We want to also report our custom
error values in HRESULT. What's the right way to do this?
"Sasha" <Sasha@discussions.microsoft.com> wrote in message
> We have methods that all return HRESULT. We want to also report our custom
> error values in HRESULT. What's the right way to do this?
See "Error Handling (COM)" at
In particular, read the section on "Usi...