Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 57
  • Last Modified:

Fasten The Updating Process Watch 11

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
Naresh Patel
Asked:
Naresh Patel
  • 7
  • 3
1 Solution
 
Ejgil HedegaardCommented:
Automatic calculation turned off during update.
Funds-Watch-v10.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Too Fast :)  Let Me Check
0
 
Naresh PatelTraderAuthor Commented:
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Naresh PatelTraderAuthor Commented:
it is really super fast Updating....Awesome.

Thanks
0
 
Naresh PatelTraderAuthor Commented:
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
 
Naresh PatelTraderAuthor Commented:
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
 
Ejgil HedegaardCommented:
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
 
Naresh PatelTraderAuthor Commented:
Perfect...let me know when i post question for creating PDFs?

Thank You very Much ....you gave me edge over others....
0
 
Ejgil HedegaardCommented:
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
 
Naresh PatelTraderAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now