Microsoft Office
Microsoft Office questions? Ask an IT Expert for support ASAP
Connect one-on-one with {0} who will answer your question
Answered in 6 hours by:
11/14/2012
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 544
Experience: Expert VBA Programmer.
Verifiedyegarboy :
You might try adding a Refresh code to the ThisWorkbook section of the VBA editor. Its located just below the last sheetname in the list. Place this code in the WorkBook_Open event so it looks like this.
Private Sub Workbook_Open()
ThisWorkbook.RefreshAll
End Sub
Let me know how it goes :)
yegarboy :
Hi there :)
yegarboy :
Are you able to reply?
Try this instead.
Private Sub Workbook_Open()
Dim x As Worksheet
For Each x In ThisWorkbook.Worksheets
x.Calculate
Next x
End Sub
Private Sub Workbook_Open()
Dim x As Worksheet
For Each x In ThisWorkbook.Worksheets
x.Calculate
Next x
End Sub
Ryan-CTech, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 544
Experience: Expert VBA Programmer.
VerifiedRyan-CTech and 87 other Microsoft Office Specialists are ready to help you
How JustAnswer works
Describe your issueThe assistant will guide you
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
100% satisfaction guaranteeGet all the answers you need
Related Microsoft Office Questions
I've created a report to count the number of days from the
Second Opinion] I've created a report to count the number of days from the start to completion and exclude weekends and holidays using the Workday formula + holidays. However, it is excluding the holi… read more
projectx2501-PHD-DBA
Chief Informations Officer
Doctoral Degree
1,012 satisfied customers
Michael, I have an issue with reporting that I believe you
Hi Michael , I have an issue with reporting that I believe you would be the best resource for. I am working on the same workbook with data entered that now need to be reported out onto the "Master Rep… read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
I need to have information on one sheet populate onto
Hello, I need to have information on one sheet populate onto another sheet (summary sheet) based on a yes or no drop down selection. … read more
Kaiser
Computer Engineer I
Bachelor of Science in Mechanical Engineering
2,889 satisfied customers
Im looking to present data from a sheet Ive recieved and I
Hello, Im looking to present data from a sheet Ive recieved and I need help … read more
Kaiser
Computer Engineer I
Bachelor of Science in Mechanical Engineering
2,889 satisfied customers
My Microsoft excel sheet is corrupted and won't allow me to
My Microsoft excel sheet is corrupted and won't allow me to open it. I've tried using a file repair program and it didn't work. What file repair programs are compatible with Excel 2019 or 2020 … read more
Andy Tech
IT System Administrator
Bachelor of Computer Science
6,130 satisfied customers
Need assistance with a workbook that has become corrupted.
Need assistance with a workbook that has become corrupted. Is there a way to privately pay for assistance with the workbook as I need this up and going no later than Monday morning! … read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
I have an excel 2016 spreadsheet with over 200 tabs. Each
I have an excel 2016 spreadsheet with over 200 tabs. Each tab represents a unique balloon loan file. Cell B16 (on each tab) displays the amount due to the lender after all regular payments have been m… read more
The-PC-Guy
Computer Manager
Bachelor's Degree
877 satisfied customers
I'm developing several spreadsheets in a workbook that have
I'm developing several spreadsheets in a workbook that have data listed in columns in each spreadsheet. I want to pull the data from each spreadsheet into a summary spreadsheet that lists the data elements across a row. I have tried to do this using the $CR command but when I copy this the data remains the same as what is reflected in the first data cell. Is there another command that I should use? Thank you. … read more
Jess
Bachelor's Degree
2,637 satisfied customers
I am working with a workbook with multiple sheets supposedly
I am working with a workbook with multiple sheets supposedly with linked cells. The "=" formulas in the destination cells appear to be correct, but when I change data in a source cell, the change does… read more
Steve
Consultant
Bachelor
298 satisfied customers
I am trying to count the number of results found in each
I am trying to count the number of results found in each subtotal and count the results that are greater than 20 so I can get a percentage of results over my criteria in each subtotal group.… read more
Bruce Wilner
Master of Engineering
33 satisfied customers
Needing help to pull data from an Excel report into a word
Needing help to pull data from an Excel report into a word document. Basically to create a pull ticket for PTA spirit wear order fulfillment. The spreadsheet contains columns of merchandise with the s… read more
Bhavik Joshi
Computer Science and Engineering
1,190 satisfied customers
Zabo I am happy with your latest formula and have just
Hi ZaboI am happy with your latest formula and have just started this so I can now pay you.… read more
Zabo04
Computer Enthusiast
Master's Degree
73 satisfied customers
I need a formula that will allow me to calculate data from
I need a formula that will allow me to calculate data from columns into number of daily visits by staff to clients seen per day. I have a column with date of visit, another column with staff name (e.g… read more
Zabo04
Computer Enthusiast
Master's Degree
73 satisfied customers
I am trying to write an excel formula that I can run a
I am trying to write an excel formula that I can run a rolling average of 30 numbers but I have zeros inter mixed with my average and I want it to not only to exclude the zeros in the value but also i… read more
Zabo04
Computer Enthusiast
Master's Degree
73 satisfied customers
Excel Im trying to organize some columns on a spreadsheet
Excel I'm trying to organize some columns on a spreadsheet I'm doing (for expenditures)... I have a column that has the dollar amounts that I spent on each item. Is there a way that the program can au… read more
Viet - Computer Tech
Computer Technican
Bachelor's Degree
27,824 satisfied customers
Help! Im in a .xlsx doc. My spreadsheet which has simple
Help! I'm in a .xlsx doc. My spreadsheet which has simple summation calculations in columns won't click and drag updated calculations. Instead it repeats the calculation from the previous column even … read more
Zabo04
Computer Enthusiast
Master's Degree
73 satisfied customers
A few days ago I was using a spreadsheet with many different
A few days ago I was using a spreadsheet with many different formulas summing up columns and rows for my rental properties. today all the formulas are gone. The numbers are there. I thought perhaps th… read more
technicalcat
Computer Science
1,859 satisfied customers
I am working on an excel spread sheet that is pulling information
I am working on an excel spread sheet that is pulling information from another spreadsheet. I am trying to copy a spreadsheet by right clicking on the tab then Copy. Error message comes up with: This … read more
Pete
4,068 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
JustAnswer in the News:
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
What Customers are Saying:
My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.
New York
Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.
Freshfield, Liverpool, UK
This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!
Los Angeles, CA
Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.
Hesperia, CA
I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.
Kernersville, NC
Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.
Woodstock, NY
Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.
Elkton, Maryland
< Previous | Next >
Meet the Experts:
The-PC-Guy
Computer Manager
877 satisfied customers
20 years experience providing remote computer support
Shefin
Microsoft Office Specialist
701 satisfied customers
Working as Tech support specialist with a world famous computer manufacturer
Miro
Computer Support Specialist
229 satisfied customers
Bachelor's Degree in Information Technology, Microsoft Certified Professional
Steve Herrod
Computer Support Specialist
132 satisfied customers
Trained in Microsoft Office from 2000 through to latest version 2010.
Zabo04
Computer Enthusiast
73 satisfied customers
Experienced in Word, Excel, Access, Powerpoint, and Outlook.
Travis
Computer Enthusiast
32 satisfied customers
I have 12 years of experience in the IT field.
Val B
Analyst / Trainer
31 satisfied customers
Expert in solving Microsoft Office problems.
< Previous | Next >
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
