 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / January 2004Pasting Formulae
I created a spreadsheet with a formula in A1 repeated throughout A2 to A499. Cell A1 was CONCATENATE etc which was fine and the whole sheet was protected. When I unprotected the sheet and amended the formula, only the new value was shown but the formula had disappeared. All other cells were fine except A1! The recalculated value has replaced the original formula. Anyone any ideas? Martin Show us the formula for A1 and give the steps you used to "amend" it. Sounds like you just "overwrote" it rather than amended it. Gord Dibben Excel MVP >I created a spreadsheet with a formula in A1 repeated >throughout A2 to A499. Cell A1 was CONCATENATE etc which [quoted text clipped - 5 lines] > >Anyone any ideas? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.