Solved

Fasten The Updating Process Watch 11

Posted on 2016-07-26
10
36 Views
Last Modified: 2016-07-27
I had this question after viewing Watch V10.

Hi Experts,

i have one file which downloads data and update to particular sheets ...i need to fast the updating process.

See Attached
Funds-Watch-v9.xlsm
0
Comment
Question by:itjockey
  • 7
  • 3
10 Comments
 
LVL 22

Expert Comment

by:Ejgil Hedegaard
ID: 41729952
Automatic calculation turned off during update.
Funds-Watch-v10.xlsm
0
 
LVL 8

Author Comment

by:itjockey
ID: 41729953
Too Fast :)  Let Me Check
0
 
LVL 8

Author Comment

by:itjockey
ID: 41729955
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Author Comment

by:itjockey
ID: 41729983
it is really super fast Updating....Awesome.

Thanks
0
 
LVL 8

Author Comment

by:itjockey
ID: 41730009
May i ask FollowUp for Funds Watch....This Regarding Creating PDF Files For Each Sheets via Macro. Like One PDF For DashBoard Lumsum As On DateRolling Return LumSum - Mid Cap i.e. PDF for for sheets --
1) Dash Board LumSum As On Date.pdf
2) Dash Board SIP As On Date.pdf
3) Rolling Returns LumSum - Mid Cap.pdf
4) Rolling Returns LumSum - LargeCap.pdf
like wise all type for LumSum as well as pdfs for  Rolling Returns SIP for all types..
one Click and all PDFs Being generated and save to predefined location if location not found then save to  workbook location.

currently i do this manually and i am not smart enough to even creating pdfs...See attached it is not properly arrange in tables.GapsSee PDFs
Thanks
Rolling-Return-Sectoral-LumSum.pdf
0
 
LVL 8

Author Comment

by:itjockey
ID: 41730032
Sir seems major fault .....regarding this question.....except button in setting Sheet for data update all other buttons and drop down  in related sheet behaving weirdly....Please Check
Same DataWeird Schemes
Thanks
0
 
LVL 22

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 41730195
Last question, dashboards not updating.
Reason is that calculation is manual.
See lower left corner of sheet, where it shows Calculate.
Sorry, forgot a line in the update macro.
Use the reset macro Ctrl+Shift+R.
Here is a new file.

I will look at the pdf files creation.
Funds-Watch-v10.xlsm
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 41731192
Perfect...let me know when i post question for creating PDFs?

Thank You very Much ....you gave me edge over others....
0
 
LVL 22

Expert Comment

by:Ejgil Hedegaard
ID: 41731705
You can post now.

Considering the above problem, I will add turning on automatic calculation in the dashboard and rolling subs so it won't happen again.
0
 
LVL 8

Author Comment

by:itjockey
ID: 41731792
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question