Help - I am a little flummoxed because I use Excel a lot and this is the
first time this has happened. When I try to copy a small worksheet with
formulas from one one spreadsheet to another, the formulas are converted to
values (as if I used "paste special" and checked values.) This now occurs
whether I try to copy with a sheet, to another sheet in the same file or
another file. It occurs whether I just select the work I did or click on the
upper left hand corner and select the whole sheet. The only solution that
works partially is to use "Paste Special" and check "formulas", but that
still does not preserve any of the other formatting (column width etc...)
Have I hit a switch somewhere, and how do I switch it back? I really
appreciate any help I can get with this.