Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Fasten The Updating Process Watch 11

Posted on 2016-07-26
10
Medium Priority
?
51 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:Naresh Patel
  • 7
  • 3
10 Comments
 
LVL 23

Expert Comment

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

Author Comment

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

Author Comment

by:Naresh Patel
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:Naresh Patel
ID: 41729983
it is really super fast Updating....Awesome.

Thanks
0
 
LVL 8

Author Comment

by:Naresh Patel
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:Naresh Patel
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 23

Accepted Solution

by:
Ejgil Hedegaard earned 2000 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:Naresh Patel
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 23

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:Naresh Patel
ID: 41731792
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
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 …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

886 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