Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board

Go Back   Horse Racing Forum - PaceAdvantage.Com - Horse Racing Message Board > Off Topic > Off Topic - Computers


Reply
 
Thread Tools Rate Thread
Old 03-03-2021, 10:17 PM   #1
Achilles
Registered User
 
Join Date: Mar 2005
Posts: 121
Excel help needed

When I tried to add new data to a spreadsheet, I found that the formulas have disappeared. I was entering data in row 64, and all the data in the first 63 rows was reduced to the result of the operation of the formula (a number or a letter) with no formula shown in the cells. I can fix it the hard way, by entering formulas in row 64, and then extending them upward and downward within each column. However, I'm pretty sure that I must have done one thing inadvertently, and maybe someone more knowledgeable can help me fix it more easily.
Thanks in advance for any advice.


JK
__________________
Achilles

-----Being unable to assume an initial premise with any tolerable degree of accuracy, I am loathe to assert a conclusion, fearful lest I should err.
Achilles is offline   Reply With Quote Reply
Old 03-04-2021, 12:32 AM   #2
tupper
Registered User
 
tupper's Avatar
 
Join Date: Jan 2007
Location: Los Angeles
Posts: 407
"Save early, save often... and always backup!" Then, you can just revert to your last recently saved version.

However, it is easy enough just to highlight 63 rows of a column(s) and past the formula(s).
tupper is offline   Reply With Quote Reply
Old 03-04-2021, 06:35 AM   #3
Achilles
Registered User
 
Join Date: Mar 2005
Posts: 121
Excel Help

Tupper,


Thank you for the reply...............JK
__________________
Achilles

-----Being unable to assume an initial premise with any tolerable degree of accuracy, I am loathe to assert a conclusion, fearful lest I should err.
Achilles is offline   Reply With Quote Reply
Old 03-04-2021, 09:00 PM   #4
tupper
Registered User
 
tupper's Avatar
 
Join Date: Jan 2007
Location: Los Angeles
Posts: 407
Well, if your Excel auto-save/auto-recover feature is enabled, there might be a saved copy of the file hiding somewhere.
tupper is offline   Reply With Quote Reply
Reply




Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

» Advertisement
» Current Polls
preferred pick 5 type
Powered by vBadvanced CMPS v3.2.3

All times are GMT -4. The time now is 09:45 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Copyright 1999 - 2021 -- PaceAdvantage.Com -- All Rights Reserved
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program
designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.