The Mega-Calc spreadsheets should not require a password to be unlocked however sometimes the spreadsheet will open in "Protected View" and you will need to click on "Enable Editing" to allow for data to be entered.
On opening you will see two tabs on the excel file:
1) Instructions: specific instructions for the Mega-Calc file are provided on the first worksheet of the file.
2) MegaCalc: Data should only be entered into the "Mega-Calc" work sheet of the file.
The yellow / orange cells in the Mega-Calc file are unlocked while all other cells are locked.
Data should only be entered into yellow / orange cells by typing or using "paste value".
If you try to paste or type into cells that are locked you will receive an error message.
Pasting data across a range of cells may also generate an error message. This is because the range of cells may contain some locked cells that are hidden.
If this happens try entering data individually into the yellow / orange cells.
1) Instructions: specific instructions for the Mega-Calc file are provided on the first worksheet of the file.
2) MegaCalc: Data should only be entered into the "Mega-Calc" work sheet of the file.
The yellow / orange cells in the Mega-Calc file are unlocked while all other cells are locked.
Data should only be entered into yellow / orange cells by typing or using "paste value".
If you try to paste or type into cells that are locked you will receive an error message.
Pasting data across a range of cells may also generate an error message. This is because the range of cells may contain some locked cells that are hidden.
If this happens try entering data individually into the yellow / orange cells.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article