Search results for query: *

How can I reduce size of excel files

I'm using an excel worksheet with automatic graph based on advanced filter. I protect my project with password but when I want to save the workbook, there is message informing me that I can not save this file when project is protected!!? Excel crash....and when I wanrt to reopen the...

When workseet is not protected, users can cancel formulas when typing in cell with formulas. I would like to know if there is a way to rest all formulas in a sheet.

I would like to calculate : End Date (B1) from a Start Date (A1) + Duration (C1) in Working days (without WE & holidays) BUT if cell D1=1 ,Saterdays are working days too. WORKDAY function consider only monday to Friday as working days! How to do it?

I would like to calculate : End Date (B1) from a Start Date (A1) + Duration (C1) in Working days (without WE & holidays) BUT if cell $D$1=1 ,Saterdays are working days too. WORKDAY function consider only monday to Friday as working days! How to do it?

In the 1st Sheet Column A, I introduce list of articles (text). I would like to know if there is a way to create automaticaly in Sheet 2 Column A a list of all articles sorted alphabeticaly ; Same articles may appear several time in Sheet1 but ONLY once in Sheet2.

function WORKDAY can calculate a date from start Date & duration , excluding weekends & holidays. How to calculate a date , excluding holidays but including weekends?

If I protect Excel Sheet, AutoFilter don't work. What can I do to enable AutoFilter in protected sheet?

I would like to calculate a End Date (B1) from a Start Date (A1) + Duration (C1) ; Duration is in Working days (without WE & holidays) BUT including saterdays (this is the problem!)

I would like to calculate a End Date (B10 from a Start Date (A1) + Duration (C1) ; Duration in Working days (without WE & holidays) BUT including saterdays (this ids the problem!)

I would like to calculate End Date from Start Date + Duration in day excluding holidays. For this Workday function is OK, but if I want to include saterdays as Working Day (excluding when saterdays are holiday , of course)?

In Excel,is-it possible to use List of choice (Data/Validation/List) with a Legend. List Range = A1:A100 (list of codes) In B1:B1000 are description of the codes (Legend) When I have to select a code in the List, I would like to see his description,but, when I select the code , only the code...

Is-it possible to use List of choice (Data/Validation/List) with Legend. List Range = A1:A100 (list of codes) In B1:B1000 are description of the codes (Legend) When I have to select a code in the List, I would like to see his description,but, when I select the code , only the code itself is...

Is-it possible to insert in cells (in a defined range of cells) automatic comments (from a an other worksheet) exemple: In the column D I have to enter a code (1 to 10);the code is corresponding to a description -this desription is mentionned in an other worksheet (column A=code;column...

How can I insert comments in a cell from VBA; comments are variables;Text inserted from a Form.

When I want to close Excel, I get the following message: "EXCEL caused error in VBE6.DLL" May-be somebody can help me to solve this problem