Home > Forum Home > Excel Portfolio Optimization Template > Error while pasting historic data Share

Error while pasting historic data

Excel Help for Error While Pasting Historic Data in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

Error While Pasting Historic Data

Rate this:
(3/5 from 1 vote)
ConfusedHi,

I am trying to paste historic prices (obtained from Bloomberg) into the historic price rows of the the model and I am getting the following error :

"The cell or chart you are trying to change is protected and therefore read only

To modify a protected cell or chart , first remove protection using the Unprotect sheet command. You maybe prompted for a password"

As a result , I am not able to change those values once I have pasted them and saved my work.

Can someone please troubleshoot this?

Best,
hansy

 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
OopsYou may need to paste the dates column separately from the historic price data columns.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Error while pasting historic data in the