When I open a workbook, excel asks if I want to update the links. I have looked everywhere, and I can not find any links in my formulas?

620

---

In visual basic, I can set the color of a cell with the .interior.colorindex property. How can I read the color of a cell before I change it?

626

---

How do I clear all formatting and cell contents from the cell in my spreadsheet?

709

---

Is there an easier way to change formula results to fixed values in microsoft excel? I usually copy the cells that I am working with and then use the paste specialcommand to past the permanent values over the original formulas?

650

---

Why do my scrollbars go to row 500 -- my data ends in cell e50?

647

---

Can I write a formula that returns the number of distinct entries in a range?

640

---

I create lots of graphs with excel. Unfortunately, the options to which excel defaults are not the ones I use most. Is there any way to change the graph defaults to theones I prefer?

605

---

Show excel toolbars on two rows?

706

---

I am converting from quatro pro to excel. What happened to my cell comments?

671

---

How to open a new copy of a excel file?

694

---

When I try to open xl, it freezes and all I can do is reboot* excel crashes on me regularly, what can I do* excel caused an invalid page fault...* Illegal operation error when starting excel?

637

---

When I clear a large range, it takes forever. How can I make it faster?

591

---

I have lost my password in ms excel?

577

---

How can I copy the name of the worksheet tab to a cell in the worksheet?

601

---

All of a sudden, when I open the file, it asks if I want to "enable or disable a macro". There are no macros in this workbook?

643

---