How can i keep formulas in a spread sheet when it is saved over?

N

Niek Otten

Please put your question in the body of your message. There are several
systems that can't cope with empty messages.

What do you mean with "keep formulas" and "is saved over"?

--
Kind regards,

Niek Otten

"saveas getting rid of formulas" <saveas getting rid of
(e-mail address removed)> wrote in message
news:[email protected]...
 
P

Pete

It sounds like "Can I have my cake and eat it?", i.e. can I have the
formulae AND the values they produce (presumably fixed with Paste
Special) ?

You can only do this if the values are copied into another area or onto
another sheet.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can I Delete data in a spread sheet and keep formulas 1
how do I create a formula to view a whole week 0
Can I change the colours on a spreadsheet with an if formula? 0
How can I set a row to have a different color if it has a +ve val. 1
I accidently saved over my spread sheet 2
For contrast, how can I change color of cursor? 0
tell me the formula of converting amount to million from koror 1
how can i set up the template? 0

Top