Solved

Fasten The Updating Process Watch 11

Posted on 2016-07-26
10
26 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 21

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
 
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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 21

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 21

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

746 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now