Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Fasten The Updating Process Watch 11

Posted on 2016-07-26
10
Medium Priority
?
47 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

722 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