General

Excel 2007 data connection
I've set up a connection to an Access DB to pull data over for my worksheet. Once the connection is made, and the data is over, I can no longer open the file if I'm not connected to the network. Is there some setting that I'm just not seeing where I have to set it to cache the results? ... 9 Mar 2010 15:50

Excel freezes after paste HTML from IE
Hi, I have Excel 2003 installed. Whenever I copy text or table from IE7 and paste into Excel (default HTML format), Excel will freeze up (cursor shows busy all the time). But if go to task manager, all applications show running smoothly. CPU 98% idle and memory is running OK. Then I had to manually end the task ... 9 Mar 2010 12:22

What if I forgot the password protecting an excel workbook?
I forgot the password I set to protect an excel file, how can I recall the password to unprotect the file? thank you in advance MG ... 9 Mar 2010 11:12

text & formual problem combined
When I combine text and a formula - i.e. ="Avg "& SUM(D30) - it comes out as Avg 0.286253661284266 but I only want it to 2 decimal points! The D30 cell contains the simple formula for £152458.70 divided by 532,600 Can someone explain or show me how I can produce an answer to 2 decimal points as "Avg 0.28"? ... 9 Mar 2010 11:12

how do i weight a series of rankings in excel?
I am trying to weight a series of performance indicators which have been created as rankings - sales / profit / etc.. i can rank on perfrmance easily but i want to weight those rankings... for instance sales is worth 60% and profit is worth 40% of total score/rank.. any ideas?! ... 9 Mar 2010 10:04

mail failure
am trying to mail one page from excel 2007 but keep getting message 'check mail installation'. have tried suggestions on the help site without success. am using windows 7, is this compatibility issue. ... 9 Mar 2010 07:50

Is it possible to use the mouse wheel to scroll horizontally?
I have a large excel document, and I wish to know if it is possible to scroll using the mouse wheel horizontally across the page, instead of the default vertical down the page? ... 9 Mar 2010 07:50

Display cell value
can anyone help me out with the option to set the cell value as below EG;- 450.00 252.12 500.00 these are the values with decimal points 450.00 but in the formula bar i.e at fx it will be displayed as 450 without any decimal point. i want some option wherein the value in the cell and the formula... 9 Mar 2010 07:50

Hidden cells
Hi, In the Excel sheet, I've clicked 'Hidden' in 'protection' tab in 'Format cells' of the cell, and then I protected the sheet. But the 'hidden' cells that I expect to have are still visible! Bst Rgds, HuaMin ... 9 Mar 2010 08:56

can excel calculate inter rater reliability?
two students are using a rating scale to independently assess the quality of medical letters. They are trying to assess to what extent their ratings agree with each other. They have ready access to excel. ... 9 Mar 2010 08:56