| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lost my formulas
Hi,
I saved my worksheet. When I went back and highlighted a cell.....it didn't show me the formula I used in the fx header.....and I forgot the formula. please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lost my formulas
On Feb 21, 10:04 am, mitch wrote:
Hi, I saved my worksheet. When I went back and highlighted a cell.....it didn't show me the formula I used in the fx header.....and I forgot the formula. please help Hi mitch. What did you save the workbook as? .xls or in another format like .csv? If you saved as csv then all formatting, functions etc will have been erased. Let us know. Kind regards,, Matt Richardson http://teachr.blogspot.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lost my formulas
On Feb 21, 6:40 am, Matt Richardson wrote:
On Feb 21, 10:04 am, mitch wrote: Hi, I saved my worksheet. When I went back and highlighted a cell.....it didn't show me the formula I used in the fx header.....and I forgot the formula. please help Hi mitch. What did you save the workbook as? .xls or in another format like .csv? If you saved as csv then all formatting, functions etc will have been erased. Let us know. Kind regards,, Matt Richardsonhttp://teachr.blogspot.com I saved as cvs....i am new to this.... no way to get formulas back? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lost my formulas
If you saved as *.csv you will still have the original *.xls file on your
computer. Unless you deleted it manually. Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 10:59:38 -0800 (PST), mitch wrote: On Feb 21, 6:40 am, Matt Richardson wrote: On Feb 21, 10:04 am, mitch wrote: Hi, I saved my worksheet. When I went back and highlighted a cell.....it didn't show me the formula I used in the fx header.....and I forgot the formula. please help Hi mitch. What did you save the workbook as? .xls or in another format like .csv? If you saved as csv then all formatting, functions etc will have been erased. Let us know. Kind regards,, Matt Richardsonhttp://teachr.blogspot.com I saved as cvs....i am new to this.... no way to get formulas back? thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lost my formulas
But not, of course, any edits done since the xls was previously saved.
Saving as csv does give a warning, and a link to a help page about what will be lost if you save in that format, and needs a confirmation before the save. I'm sure the OP will be more careful next time! -- David Biddulph "Gord Dibben" <gorddibbATshawDOTca wrote in message ... If you saved as *.csv you will still have the original *.xls file on your computer. Unless you deleted it manually. Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 10:59:38 -0800 (PST), mitch wrote: On Feb 21, 6:40 am, Matt Richardson wrote: On Feb 21, 10:04 am, mitch wrote: Hi, I saved my worksheet. When I went back and highlighted a cell.....it didn't show me the formula I used in the fx header.....and I forgot the formula. please help Hi mitch. What did you save the workbook as? .xls or in another format like .csv? If you saved as csv then all formatting, functions etc will have been erased. Let us know. Kind regards,, Matt Richardsonhttp://teachr.blogspot.com I saved as cvs....i am new to this.... no way to get formulas back? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep formulas for being lost when saving in 2007? | Excel Discussion (Misc queries) | |||
| How do I keep a running total of pounds lost and percentage lost | Excel Discussion (Misc queries) | |||
| i have lost the small + that allows mass copy of formulas in excel | Excel Discussion (Misc queries) | |||
| um... im lost | Excel Worksheet Functions | |||
| I'm Lost, Need Help | Excel Worksheet Functions | |||
Linear Mode
