I have an Excel table that consists of data being pull from various databases via odbc drivers. This part is working fine. What is happening is when I go to change the information in MS Query in Excel I get an error when I try to delete or add information to my table. The message is as follows:
"This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet"
Can someone tell me what I need to do to make changes in my table without having to start all over?
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…