3 Messages
Digest #4540
Messages
Thu May 9, 2019 6:17 pm (PDT) . Posted by:
jimmymc00
Downloaded fresh version of SMF Add-in with no change in lengthy update issue this morning.
Started pouring through Excel settings and could find nothing that needed attention. Read a lot on Excel and memory allocation without much help but it and Tom's questions did focus me more on the Excel file itself. So, I copied the data collection sheet into a file by itself to dis associate it from all the activity of the original file that pulled data from it. This newly created data worksheet had the same lengthy update issue. While playing around with it I started deleting the hidden columns associated with the defunct BarChartPortfolioView thinking it was no longer going to re immerge one day. Its previous array had been deleted back when BarChart locked us out but he column of tickers were still there along with the headers. Interestingly enough when all those columns were eliminated the problem went away. Why they suddenly started interfering is a mystery to me after months of not interfering? Something must have gone awry the last time I closed and saved the file before migrating it to new computer.
After a couple of reboots for testing I feel pretty good that the file is in good shape and operating properly in both the old and new computer.
New computer is opening apps in a fraction of the time it took old one and downloading about 50% faster. Time to look at enhancing the internet speeds. Thanks for your help.
Started pouring through Excel settings and could find nothing that needed attention. Read a lot on Excel and memory allocation without much help but it and Tom's questions did focus me more on the Excel file itself. So, I copied the data collection sheet into a file by itself to dis associate it from all the activity of the original file that pulled data from it. This newly created data worksheet had the same lengthy update issue. While playing around with it I started deleting the hidden columns associated with the defunct BarChartPortfolioVi
After a couple of reboots for testing I feel pretty good that the file is in good shape and operating properly in both the old and new computer.
New computer is opening apps in a fraction of the time it took old one and downloading about 50% faster. Time to look at enhancing the internet speeds. Thanks for your help.
Fri May 10, 2019 12:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The BarChart function was probably getting a timeout from not finding the
requested web resource? It could be you were picking up a cached copy of
the web page on your old computer? Did you not have the IE options set to
always get a fresh copy of a web page on the old machine?
On Thu, May 9, 2019 at 6:17 PM jmcatee133@... wrote:
>
> Downloaded fresh version of SMF Add-in with no change in lengthy update
> issue this morning.
> Started pouring through Excel settings and could find nothing that needed
> attention. Read a lot on Excel and memory allocation without much help but
> it and Tom's questions did focus me more on the Excel file itself. So, I
> copied the data collection sheet into a file by itself to dis associate it
> from all the activity of the original file that pulled data from it. This
> newly created data worksheet had the same lengthy update issue. While
> playing around with it I started deleting the hidden columns associated
> with the defunct BarChartPortfolioView thinking it was no longer going to
> re immerge one day. Its previous array had been deleted back when BarChart
> locked us out but he column of tickers were still there along with the
> headers. Interestingly enough when all those columns were eliminated the
> problem went away. Why they suddenly started interfering is a mystery to
> me after months of not interfering? Something must have gone awry the last
> time I closed and saved the file before migrating it to new computer.
> After a couple of reboots for testing I feel pretty good that the file is
> in good shape and operating properly in both the old and new computer.
> New computer is opening apps in a fraction of the time it took old one and
> downloading about 50% faster. Time to look at enhancing the internet
> speeds. Thanks for your help.
>
>
requested web resource? It could be you were picking up a cached copy of
the web page on your old computer? Did you not have the IE options set to
always get a fresh copy of a web page on the old machine?
On Thu, May 9, 2019 at 6:17 PM jmcatee133@.
>
> Downloaded fresh version of SMF Add-in with no change in lengthy update
> issue this morning.
> Started pouring through Excel settings and could find nothing that needed
> attention. Read a lot on Excel and memory allocation without much help but
> it and Tom's questions did focus me more on the Excel file itself. So, I
> copied the data collection sheet into a file by itself to dis associate it
> from all the activity of the original file that pulled data from it. This
> newly created data worksheet had the same lengthy update issue. While
> playing around with it I started deleting the hidden columns associated
> with the defunct BarChartPortfolioVi
> re immerge one day. Its previous array had been deleted back when BarChart
> locked us out but he column of tickers were still there along with the
> headers. Interestingly enough when all those columns were eliminated the
> problem went away. Why they suddenly started interfering is a mystery to
> me after months of not interfering? Something must have gone awry the last
> time I closed and saved the file before migrating it to new computer.
> After a couple of reboots for testing I feel pretty good that the file is
> in good shape and operating properly in both the old and new computer.
> New computer is opening apps in a fraction of the time it took old one and
> downloading about 50% faster. Time to look at enhancing the internet
> speeds. Thanks for your help.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar