4 Messages
Digest #4266
2b
Re: Formula problem for multiple stock entries in smfGetYahooPorfoli by "Randy Harmelink" rharmelink
Messages
Fri Dec 15, 2017 7:11 am (PST) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
Apparently I've added too many cells with conditional formatting, at least that seems to be the last thing I did that is bogging down my spreadsheet.
Now it's taking a ridiculously long time to finish calculating after opening the spreadsheet. I'd like to go in and clean up some of these things to reduce the load, but it's hanging up about 5—7% in to the opening calculations.
How can I open the spreadsheet to work with it, without it trying to do the opening calculations? Or, just get it to stop calculating so I can delete some of the fetching?
Thanks,
Jim
Apparently I've added too many cells with conditional formatting, at least that seems to be the last thing I did that is bogging down my spreadsheet.
Now it's taking a ridiculously long time to finish calculating after opening the spreadsheet. I'd like to go in and clean up some of these things to reduce the load, but it's hanging up about 5—7% in to the opening calculations.
How can I open the spreadsheet to work with it, without it trying to do the opening calculations? Or, just get it to stop calculating so I can delete some of the fetching?
Thanks,
Jim
Fri Dec 15, 2017 9:42 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You can try turning off automatic recalculation before opening the workbook.
Often when I've had an add-in workbook "hanging" or taking much longer than
normal, it's because one of the websites I retrieve data from is either
slow or down. The add-in can't continue until the website responds or the
request times out (usually 60 seconds or so). For example, one of my
spreadsheets was slow today. When I checked my logs, it showed GuruFocus
was taking about 14 seconds for each web page request.
On Fri, Dec 15, 2017 at 8:11 AM, 'Jim Ranum' amt2100@
...
wrote:
> Apparently I've added too many cells with conditional formatting, at least
> that seems to be the last thing I did that is bogging down my spreadsheet.
>
> Now it's taking a ridiculously long time to finish calculating after
> opening the spreadsheet. I'd like to go in and clean up some of these
> things to reduce the load, but it's hanging up about 5—7% in to the opening
> calculations.
>
> How can I open the spreadsheet to work with it, without it trying to do
> the opening calculations? Or, just get it to stop calculating so I can
> delete some of the fetching?
>
Often when I've had an add-in workbook "hanging" or taking much longer than
normal, it's because one of the websites I retrieve data from is either
slow or down. The add-in can't continue until the website responds or the
request times out (usually 60 seconds or so). For example, one of my
spreadsheets was slow today. When I checked my logs, it showed GuruFocus
was taking about 14 seconds for each web page request.
On Fri, Dec 15, 2017 at 8:11 AM, 'Jim Ranum' amt2100@
...
wrote:
> Apparently I've added too many cells with conditional formatting, at least
> that seems to be the last thing I did that is bogging down my spreadsheet.
>
> Now it's taking a ridiculously long time to finish calculating after
> opening the spreadsheet. I'd like to go in and clean up some of these
> things to reduce the load, but it's hanging up about 5—7% in to the opening
> calculations.
>
> How can I open the spreadsheet to work with it, without it trying to do
> the opening calculations? Or, just get it to stop calculating so I can
> delete some of the fetching?
>
Fri Dec 15, 2017 11:12 am (PST) . Posted by:
dcrapo
Randy, thanks so much for improving the add-in so that it can accommodate multiple entries of the same stock in an smfGetYahooPortfolioView array. Your commitment to this project is amazing.
I have been trying to change the 'multiple" parameter to "Y" in the array formula as you have suggested, but have not had success. My Excel formula abilities are limited so I have been trying dozens of attempts - - all futile.
Does anyone have an example of an array formula that they have successfully used that I could adapt?
Doug
I have been trying to change the 'multiple" parameter to "Y" in the array formula as you have suggested, but have not had success. My Excel formula abilities are limited so I have been trying dozens of attempts - - all futile.
Does anyone have an example of an array formula that they have successfully used that I could adapt?
Doug
Fri Dec 15, 2017 11:25 am (PST) . Posted by:
"Randy Harmelink" rharmelink
When changing an array-entered formula, you have to make sure you select
the entire range the formula is entered over. So:
1. Highlight the entire range (I sometimes forget to include the header
line).
2. Hit F2 to edit the formula and make your changes
3. Hit ctrl+shift+enter to save the changes
If you get the message "You can't change part of an array", then you didn't
do step (1) correctly. :(
On Fri, Dec 15, 2017 at 12:12 PM, dcrapo@
...
wrote:
> Randy, thanks so much for improving the add-in so that it can accommodate
> multiple entries of the same stock in an smfGetYahooPortfolioView array.
> Your commitment to this project is amazing.
>
> I have been trying to change the 'multiple" parameter to "Y" in the array
> formula as you have suggested, but have not had success. My Excel formula
> abilities are limited so I have been trying dozens of attempts - - all
> futile.
>
> Does anyone have an example of an array formula that they have
> successfully used that I could adapt?
>
>
>
the entire range the formula is entered over. So:
1. Highlight the entire range (I sometimes forget to include the header
line).
2. Hit F2 to edit the formula and make your changes
3. Hit ctrl+shift+enter to save the changes
If you get the message "You can't change part of an array", then you didn't
do step (1) correctly. :(
On Fri, Dec 15, 2017 at 12:12 PM, dcrapo@
...
wrote:
> Randy, thanks so much for improving the add-in so that it can accommodate
> multiple entries of the same stock in an smfGetYahooPortfoli
> Your commitment to this project is amazing.
>
> I have been trying to change the 'multiple" parameter to "Y" in the array
> formula as you have suggested, but have not had success. My Excel formula
> abilities are limited so I have been trying dozens of attempts - - all
> futile.
>
> Does anyone have an example of an array formula that they have
> successfully used that I could adapt?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar