Reset VBA Scripting to Default

[talltai]

Apparently, I ran a macro that impacted my library and in doing so I can no longer do basic excel formulas. For example, when I do a copy and paste from A1 across columns B:I to return the associated values on another page it simply repeats the result listed in cell A1. A look into the formula of each cell shows the proper formula but what is visible as the result is what was in cell A1.

How do I restore my libraries or whatever else to the factory version to clear whatever i did. I work for a corporation so I am unable to function as an adminstrator.

 

[talltai]

For clarification the basic formula i am doing is:

=Admin!A1

or
=Sheet1!A1

 

[MrKowz]

Welcome to the forums!

Open the VBA Editor (alt+F11) and go to the "Immediate" Pane. If you don't see this, press CTRL+G to open it.

In the immediate pane, enter the following lines, pressing enter after each line

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

It sounds like your calculations are turned off, but this should cover the bases.

 

[Fluff]

Hi
Sounds like Calculation has been set to manual
Goto Tools>Options>Calulation and then select Automatic

 

[talltai]

Thank you so much! That was it. I am so appreciative of the quick replies.

 

[Fluff]

Glad WE could help & thanks for the feedback