6 Messages
Digest #3038
Messages
Tue Apr 8, 2014 1:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It should affect both machines if that was the issue...I interpreted his
problem as only one machine was giving errors, while the other one worked
OK.
On Tue, Apr 8, 2014 at 12:59 PM, Randy Randall <positive.theta@gmail.com>wrote:
>
> colinmmoors@yahoo.com wrote: "it is a huge spreadsheet which I have to
> recalc manually."
>
> Randy H: Could this be symptomatic of exceeding the number of web pages?
>
> Randy R
>
problem as only one machine was giving errors, while the other one worked
OK.
On Tue, Apr 8, 2014 at 12:59 PM, Randy Randall <positive.theta@gmail.com>wrote:
>
> colinmmoors@yahoo.com wrote: "it is a huge spreadsheet which I have to
> recalc manually."
>
> Randy H: Could this be symptomatic of exceeding the number of web pages?
>
> Randy R
>
Tue Apr 8, 2014 1:07 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Watch Cody's video
Not sure if this helps but I just put a quick video together on eliminating the hard coded location when downloading files. I believe the sheets must be unprotected to make changes.
https://www.youtube.com/watch?v=hSv-HLA1Rqo
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of colinmmoors@yahoo.com
Sent: Tuesday, April 08, 2014 3:17 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] 2 pc's get 2 different results RCHGetTableCell
the problem seems to be specific to the workbook; if I open a new workbook on the same problem PC and paste the same formula, it works. In fact, the problem workbook does work intermittently. it is a huge spreadsheet which I have to recalc manually. strange that it is an intermittent problem - once it returns an error for a symbol, it constantly returns an error - until I re-open the workbook. strange. I'd rather not have to rebuild the workbook
Not sure if this helps but I just put a quick video together on eliminating the hard coded location when downloading files. I believe the sheets must be unprotected to make changes.
https://www.youtube.com/watch?v=hSv-HLA1Rqo
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of colinmmoors@yahoo.com
Sent: Tuesday, April 08, 2014 3:17 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] 2 pc's get 2 different results RCHGetTableCell
the problem seems to be specific to the workbook; if I open a new workbook on the same problem PC and paste the same formula, it works. In fact, the problem workbook does work intermittently. it is a huge spreadsheet which I have to recalc manually. strange that it is an intermittent problem - once it returns an error for a symbol, it constantly returns an error - until I re-open the workbook. strange. I'd rather not have to rebuild the workbook
Tue Apr 8, 2014 5:46 pm (PDT) . Posted by:
colinmmoors
I'm thinking it has something to do w the size of the workbook and the large amounts of queries
Tue Apr 8, 2014 4:54 pm (PDT) . Posted by:
linhle1784
Hi all, I'm having tough times trying to open the aforementioned cash flow model uploaded by user "stu00537"; under the "Templates by Users" tab. When I opened the spreadsheet Excel prompted me to "enable links" and update the source which i did but to no avail. Please help and thank you.
Le
Le
Tue Apr 8, 2014 5:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
See this video just posted today by another user of the add-in:
https://www.youtube.com/watch?v=hSv-HLA1Rqo
I usually just run the smfFixLinks macro (a macro within the add-in that I
have assigned to a toolbar button). It does the same "find and replace"
without needing you to do anything other than run the macro.
I haven't found the "Update the source" process to work consistently in the
past, so I never do it.
On Tue, Apr 8, 2014 at 4:54 PM, <linhle1784@yahoo.com> wrote:
> I'm having tough times trying to open the aforementioned cash flow model
> uploaded by user "stu00537"; under the "Templates by Users" tab. When I
> opened the spreadsheet Excel prompted me to "enable links" and update the
> source which i did but to no avail. Please help and thank you.
>
https://www.youtube.com/watch?v=hSv-HLA1Rqo
I usually just run the smfFixLinks macro (a macro within the add-in that I
have assigned to a toolbar button). It does the same "find and replace"
without needing you to do anything other than run the macro.
I haven't found the "Update the source" process to work consistently in the
past, so I never do it.
On Tue, Apr 8, 2014 at 4:54 PM, <linhle1784@yahoo.com> wrote:
> I'm having tough times trying to open the aforementioned cash flow model
> uploaded by user "stu00537"
> opened the spreadsheet Excel prompted me to "enable links" and update the
> source which i did but to no avail. Please help and thank you.
>
Tue Apr 8, 2014 5:31 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
How about providing some details?
When you click on a cell copy and paste the content into your next email.
Send me your file as is. I'll look it over. Tell me where did you install the addin? What folder? Which drive?
Send the failing file directly to me at kermitp@tampabay.rr.com
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of linhle1784@yahoo.com
Sent: Tuesday, April 08, 2014 7:54 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Cash Flow_17S (update)
Hi all,
I'm having tough times trying to open the aforementioned cash flow model uploaded by user "stu00537"; under the "Templates by Users" tab. When I opened the spreadsheet Excel prompted me to "enable links" and update the source which i did but to no avail. Please help and thank you.
Le
When you click on a cell copy and paste the content into your next email.
Send me your file as is. I'll look it over. Tell me where did you install the addin? What folder? Which drive?
Send the failing file directly to me at kermitp@tampabay.rr.com
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of linhle1784@yahoo.com
Sent: Tuesday, April 08, 2014 7:54 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Cash Flow_17S (update)
Hi all,
I'm having tough times trying to open the aforementioned cash flow model uploaded by user "stu00537"
Le
Tidak ada komentar:
Posting Komentar