General

Hyperlink
Can I use hyper link in one cell but link to more than one external data files? If not, how can it be done? ... 26 Apr 2010 11:24

How do I stop a Pivot Table from Sorting my data (Excel 2007)
The data in my Access database is in the order that I want it to be but my Pivot Table insists on sorting it either Ascending or Descending. I can't seem to turn this off... If I right-click on the field name and choose Sort > More Sort Options... > Manual (you can drag items to rearrange them) This makes no d... 26 Apr 2010 14:57

CountIf 2 columns
Hi I need a formula to count cells in one column containing dates depending on the contents of a differnt column like SumIf has the option ... 26 Apr 2010 10:16

Excel 2003 -insufficient Resources
I have just inserted a series of 8 calculated fields using sumproduct into a spreadsheet which references a closed workbook and have now been given the error - "Excel cannot complete this task with available resources. Choose less data or close other applications" Any bright ideas on how to make additional resou... 26 Apr 2010 11:24

forgot to attach doc sent via email, original's not saved. can it.
Someone was meant to send an important document to me via email but they forgot to attach the document, and do not have it saved on their system. Is there anyway for us to retrieve the document with the amendents included? Thanks ... 26 Apr 2010 11:24

Invalid cell reference
I am writing an Excel 2002 template, and wish to convert a large range of imported data. All of my formulae have been written in row A on a 'Reformatted Data' sheet. For example cell A1 contains =TEXT('Imported Data '!B3,"00"). The many formulae work successfully, but I need to delete the entire contents of... 26 Apr 2010 10:16

No more fonts maybe applied to this work book, Why????
I get this message when I want to change the colour of a font . I don't understand why . " No more fonts maybe applied to this work book" ... 26 Apr 2010 10:16

Hyperlink properties only from one cell to another.
Is there a way to copy the hyperlink property only from one cell or column of cells to another? I originally wanted all cells in my rows to have the same hyperlink. But then I realized I had to insert a column (B) that doesn't have a hyperlink. After I did this I lost the hyperlink to column (A) but still have it i... 26 Apr 2010 09:10

In-Cell Graph Using REPT But Proportional to Cell Width?
This is in XL2003. I'm trying to make a simple in-cell graphic that visualizes a percentage created by two other cells. Here's the formula in cell K45: =REPT("|",(I45/H45)*100) (Columns I and H contain the values from which I'm deriving a percentage.) Is there any way to alter this, though, so that it take... 26 Apr 2010 09:10

shifting cells disabled.
I am failing to drag or shift cells/rows/columns in my excel worksheet. I have reinstalled MS office XP ,but it did not help me. What should I do? ... 26 Apr 2010 09:10