I have set a file password on the excel file. Unfortunately, I have forgotten it. Is there any way to know the password or disable this function Million Thanks

Combining different worksheets into a single worksheet. Dear helpers, I am new to VBA and have the problem: To combine worksheets into a single worksheet we...

The worksheet 'job1' contains 6 workers named 'worker1'...'worker6'; The worksheet 'job2' contains 2 workers named 'worker1','worker3'; The worksheet 'job3'...

I have a simple array formula that sums 3 criterias. After I've entered the formula and do Ctrl+Shift+Enter, an error pops up stating that "Array Formulas are...

I am just trying to add simple groups of radio buttons to a worksheet for yes-or-no questions to be filled out by the user. No funtions, no data being entered....

I have Excel 2010, can anyone help me come up with a formula to create a chart that converts angles to vectors? I would like to show that Zero degrees has a...

I am trying to set up a workbook in Excel 2007 with multiple tabs and two signature lines at the bottom of each sheet. The idea is that my boss can read, sign...

Hi All, I have an issue with cascading dropdowns. I have the following data. Entity = UK, GMBH, JAPAN, SING I have then got lists of products, suppliers and...

I have a variable sized data set in a work sheet. Simplified it's like this: A B 1 data1 =Today() 2 data2 =Today() ...

In the attached excel file there are list of names and list of cities. If I select city as "DELHI" for "A", I should not get "DELHI" in subsequent drop downs....

I'm using the below formula to determine the specific type of equipment from a list named:...

I have moved a comment by dragging and dropping it. However, when I 'hover over' the cell with the comment, the comment box goes back to its original position....

I need to copy certain data from a page and move it to another form, in the same book. The basics is that data will be entered each day then the user will hit...

From a previous post. Thought this example might be easier to understand. I have an Evaluation Sheet that has four cells of different ratings each...

I want to create a code that can run through the entire spreadsheet and delete the rows of all accounts that have $0 or less Outstanding balance. Example in...

Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of...

I have a table with A-G columns and 20 rows. If I do not select column A then the "Sort & Filter" is enable. The "Format as Table" also works. As soon as I...

I'm using Excel 2007, workbook there is several sheets, I want to select the particular sheet from the first sheet, any tips please... Expl:- I'm making...

Ignore my message, below I have managed to solve the problem 8/11/10 I have a spreadsheet which will be used to calculate printing costs for each person each...

I have customers that use the Gregorian calendar ( it is 2003 now) while I keep my records in the Western Calendar (2010). Does any one know how I can convert...