|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
an xls is exported by a 3rd party app. Open said xls in v 2003. Panes frozen at a2. Column labels. Row 1 background color = yellow. AutoFilter On.
Turn off autofilter.
When i insert a new column b, and type ‘=Trim(a2)’, the formula is not evaluated. It just lies there. Delete the new B.
When I insert a column to the left of A and enter ‘=Trim(b2)’, the formula is evaluated.
What is it about the imported range that would prevent formulae from being evaluated?
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Notifications
