Hi, I have a simple excel sheet which is saved in eencrypted format. I am unable to insert rows in the same. Whenever I try, it says, 'To prevent possible...

Hi All, In our environment we have shared folders and files. Excel file is shared and able to open by all who have been given access without any issues. But...

I have two pivot tables based on the same source. However, each table is unique in how it shows the date. The first shows all thirty days of the month. The...

Is it possible to protect a worksheet for editing only by myself except for a few selected column's??

I am guessing that it's an IF Column H: Sums the total of client Column A: keeping track of clients that are "no shows" How can I sum the number of...

Dear All, Recently I have seen a exccel file. In that data of cell (contains proverbs & quotation's) were auto changing to a new one with a time interval of...

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we noticed that with all the protections turned off there were some things that we...

I have a macro to send emails which used to work but now doesn't. Whilst running it within VB it flags an error with this part:- 'Execute the URL (start the...

After reviewing some previous posts, I've come up with the following function. Ideally, I would like to give it a Name reference, but it is too long. Any...

Hi All, I have an excel sheet in which I have some protected cells and unprotected cells. The protected cells are protected so that the forumla...

I have created the following formula from by reviewing other treads. While it works, it is very long. Any suggestions for simplification? Ideally I would...

Hello, We are user Excel 2007 on windows 7 computers, and sharing files between users on a NAS. The problem is that when the original user creats a workbook,...

dear all how i can total the no. of hours when Emp ID & date is matching with below row, till the row value is change either in date or Emp.No which coming...

In Excel 2003, is it possible to conditionally format a range based on the value in one of the cells in that range. for example I have a record with several...

Even making calculations only by the Excel submitted figures are not correct from the 6 decimal place, and I updated with Office (last SP), which can...

In Excel 2007 I have a formatted table, 10 columns wide, in which 5 of the columns have formulas. There is a nice feature in Excel 2007 that allows me to...

I have uploaded the file, i need to compare the data in columns A and F. A being a master list of numbers, F being the current list. I need to display True...

Dear All Please I want formula or VB macro, to sub-total the no. of hours when Emp.ID & date is matching eg. All Emp#.ID equal to 116 with date equal to...

Hi All, I have a Query like This. Pls Give your Suggestions. DATA: anil 0 sunil 1 anil 1 sunil 0 anil 1 sunil 0

Hi Is it possible to change the colour that Excel 2003 Track Changes appears in? It's currently showing up as navy which is difficult to identify against...