eConsultant - Excel FAQ
Q1: Should I keep my data in Access or Excel?
Ans: The simple rule is : Data that requires only mathematical
manipulation should be kept in Access, while data that needs
to be logically manipulated should be kept in Access. Data that
requires complex logical reports should be kept in Access.
Q2: I use Excel 2000. Is there a way to remove hyperlinks
from the entire worksheet?
Ans: Yes, removing
all hyperlinks in one step requires a macro (new
window).