Filtering is limited to 999 items in Microsoft Excel

The number of items available for filtering is limited. Excel cannot filter columns in which the number of items exceeds 999 (not the number of rows)....

Change the Task's progress bar colours by clicking it

So Simple, Just Click the progress bar fo each task and it will change it's colour If you want to add new bars the just copy any of the existing one...

Using F2 to edit ranges in Name Manager and Conditional Formatting

I hadn't considered entering the competition. But yesterday, I once again shared this tip with an OP and thought it might be useful to bring it to a w...

how to figure out that worksheet is set to Manual Calculation mode

my pet peeve - yup - that little exasperating option that users check on to infinitely p!$$ off others... you could be changing formulae furiously and...

Getting Continuously Refreshed Data from a Web Site in Excel 2002 & 2003

Excel 2002 and Excel 2003 enables selecting an exact data table on a Web site, and importing and refreshing only the needed data. To import and ref...

Getting Continuously Refreshed Data from a Web Site in Excel 2000

To import and refresh information from a Web site: 1. Open Excel 2000, and from the Data menu, select Get External Data, and then New Web Query. 2...

Getting Continuously Refreshed Data from a Web Site in Excel 97

To get refreshed data from a Web site using Excel 97, save the site address (URL) for every new query in a text file with the extension .iqy. To sa...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube