Recent content by smallia

One thing to be careful of when using VLOOKUP (or HLOOKUP) is proper use of the 4th parameter. The formula only requires the first three params, but if the fourth param is omitted, the default value can cause unexpected results. I see this mistake often. The fourth parameter, Range_lookup...

I am using CRM 4.0. I created a custom report to export order information to an Excel spreadsheet so I can do some data analysis. I need to export all the product and pricing info contained on fulfilled orders. I've created a report using the Report Wizard. The Primary Record Type I'm...

My client is using CRM 4.0. About a month ago, they revised all of their Products, creating new product entries, names, pricing, etc. To ensure salespeople did not continue to add the old products to quotes, the status of the old products were changed to Inactive. The previous sold orders can...

Here's another way that requires only a single click. I've created a shortcut button on my taskbar to open a new email message, (as well as one for a new appointment, contact, task, and stickynote). No matter what windows I have open, a new "item" is one click away. 1. Right-click on your...

Thanks.

BlackBerry 7230 Platform: 1.6.1.41 App Version: 3.7.1.41 Earlier today, I removed my BB from the holster and on my email screen I had a pop-up window I had never seen before with 4 or 5 color icons for mail, phone, address book, and calendar (I think those were the ones, but I may be...

We're running: v3.6.0.29 BES Exchange 2000 v3.6.2.9 BB Desktop Manager v3.7.1.41 BB Handheld Software BB Model 7230 Devices On my 7230, I can view .doc and .xls documents without any problem. When I attempt to view any .pdf, I get a "Document is empty." error. When I...

I have a 7230. I would love to be able to view my eFax attachments on my Blackberry. Has anyone found an eFax viewer?

So to increase the time out periods, (per Zebed00 above), is 1200 (Decimal) identified in seconds and therefore equal to 20 minutes?

Looks like that makes a difference. Changing the cells to General doesn't correct this, but after it's changed to General, re-entering = and selecting the cell 'Time Sheet'!B8 seems to correct the problem. Thanks.

Thakns. When I do that in my second cell, it doesn't make a difference. The cell still returns the value ='Time Sheet'!B8 and not the value of cell B8 in sheet 'Time Sheet'. No change. Also, when I do what you suggested in the first cell, it replaced the valid formula, and now appears the...

Hello eveyrone. I'm using Excel 2003. I have two cells, each containing exactly "='Time Sheet'!B8" (without the double quotes). 'Time Sheet' is the name of another sheet in the same work book. The first of these two cells is interpreting the ='Time Sheet'!B8 as a formula (as...

I checked and they are the same. I'm stumped.

At work, IE v6.0 works fine and it's the browser I always use. I take my laptop home (cable modem) and IE also works fine. I take my laptop to a colleagues home (DSL) where we often work from, and I cannot open IE--it starts to open, I get the window frame, but it never fully displays. I do...

I'm not sure how, but my colleage did somehow enter a payment against this invoice. I haven't been able to duplicate the problem I had. Each invoice is now appearing as expected. Guess I'll just assume it was user error. Thanks for your reply.