<html><head></head><body><div class="ydp29a93097yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>Provided they are familiar with Excel (and sharing and formulas...etc). In my experience, people can mess those up pretty well too!</div><div><br></div><div class="ydp29a93097signature"><div style="font-family:Helvetica, Arial, sans-serif;font-size:16px;">-Garth Shaneyfelt<br><div>Let's Create a Better World</div></div></div></div>
<div><br></div><div><br></div>
</div><div id="ydp50eb4aceyahoo_quoted_1686572179" class="ydp50eb4aceyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, June 26, 2019, 11:18:01 AM EDT, Marla Michel via Hidden-discuss <hidden-discuss@lists.hidden-tech.net> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp50eb4aceyiv4539955053"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Excel online on OneDrive (for any operating system) enables multiple people to share/access/update workbooks online and skip the unfamiliar Google Sheets quirks.</div><div><br clear="none"></div><div>Excel: <a shape="rect" href="https://office.live.com/start/Excel.aspx" rel="nofollow" target="_blank">https://office.live.com/start/Excel.aspx</a></div><div>OneDrive: <a shape="rect" href="https://onedrive.live.com/" rel="nofollow" target="_blank">https://onedrive.live.com/</a></div><div>Tutorial: <a shape="rect" href="https://www.excel-easy.com/examples/onedrive.html" rel="nofollow" target="_blank">https://www.excel-easy.com/examples/onedrive.html</a></div><div><br clear="none"></div><div>Marla</div><div><br clear="none"></div></div></div></div></div><br clear="none"><div class="ydp50eb4aceyiv4539955053gmail_quote"><div class="ydp50eb4aceyiv4539955053yqt4154757275" id="ydp50eb4aceyiv4539955053yqt96440"><div class="ydp50eb4aceyiv4539955053gmail_attr" dir="ltr">On Wed, Jun 26, 2019 at 5:11 AM dlesser--- via Hidden-discuss <<a shape="rect" href="mailto:hidden-discuss@lists.hidden-tech.net" rel="nofollow" target="_blank">hidden-discuss@lists.hidden-tech.net</a>> wrote:<br clear="none"></div><blockquote class="ydp50eb4aceyiv4539955053gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid;"><div style="font-family:Verdana, Geneva, sans-serif;font-size:12pt;">
<p>One last piece of info: she and most of her office are on Macs, if that makes a difference. I do not think she knows about keyboard shortcuts, but could be inadvertently using them.</p>
<div> </div>
<p><br clear="none"></p>
<p>On 2019-06-26 6:05 am, <a shape="rect" href="mailto:dlesser@ptraining.com" rel="nofollow" target="_blank">dlesser@ptraining.com</a> wrote:</p>
<blockquote style="margin:0px;padding:0px 0.4em;border-left-color:rgb(16,16,255);border-left-width:2px;border-left-style:solid;" type="cite">
<p>A question for the group.</p>
<p>I have created a series of Google Sheets spreadsheets for a client. Her employees each fill out a timesheet, all of which are linked to a roll-up document that summarizes each week's payroll, etc. Each employee is linked to a separate sheet in the rollup sheet, which then uses some other sheets to summarize the payroll info. In my testing, these all work as designed all of the time.</p>
<p>Over the past 3 months, I have had a number of issues where the formulas in the roll up sheets become disorganized. A link to F4 will turn into F187. I solved those problems by using Absolute values (e.g. $F$4) and they do not seem to have reoccured. i have protected some ranges, but since she is the owner, she can override the protection.</p>
<p>This past week, two cells were overwritten by what looks like text from another part of the sheet (i.e., F4 and F15 were overwritten by text in F3 and F4). I do have a couple of scripts, but they simply copy the same named range each week and paste it as values on another sheet.</p>
<p>My client si not very computer literate and is very awkward in using computers. I am attributing her problems to her inadvertent copy and pasting or moving cells since I cannot find any code or other way of making these changes except by a copy or move and paste or something similar.</p>
<p>Does anyone else have these problems or any suggestions? I could do this in Excel with complete confidence that I can protect against any inadvertent changes, but Google Sheets is another beast entirely. We need to use Sheets because her office is distributed and everyone is on-line and not on a LAN.</p>
<p>Any suggestions would be appreciated.</p>
</blockquote>
</div>
_______________________________________________<br clear="none">
Hidden-discuss mailing list - home page: <a shape="rect" href="http://www.hidden-tech.net" rel="nofollow" target="_blank">http://www.hidden-tech.net</a><br clear="none">
<a shape="rect" href="mailto:Hidden-discuss@lists.hidden-tech.net" rel="nofollow" target="_blank">Hidden-discuss@lists.hidden-tech.net</a><br clear="none">
<br clear="none">
You are receiving this because you are on the Hidden-Tech Discussion list.<br clear="none">
If you would like to change your list preferences, Go to the Members<br clear="none">
page on the Hidden Tech Web site.<br clear="none">
<a shape="rect" href="http://www.hidden-tech.net/members" rel="nofollow" target="_blank">http://www.hidden-tech.net/members</a><br clear="none">
</blockquote></div></div></div></div><div class="ydp50eb4aceyqt4154757275" id="ydp50eb4aceyqt51534">_______________________________________________<br clear="none">Hidden-discuss mailing list - home page: <a shape="rect" href="http://www.hidden-tech.net" rel="nofollow" target="_blank">http://www.hidden-tech.net</a><br clear="none"><a shape="rect" href="mailto:Hidden-discuss@lists.hidden-tech.net" rel="nofollow" target="_blank">Hidden-discuss@lists.hidden-tech.net</a><br clear="none"><br clear="none">You are receiving this because you are on the Hidden-Tech Discussion list.<br clear="none">If you would like to change your list preferences, Go to the Members<br clear="none">page on the Hidden Tech Web site.<br clear="none"><a shape="rect" href="http://www.hidden-tech.net/members" rel="nofollow" target="_blank">http://www.hidden-tech.net/members</a><br clear="none"></div></div>
</div>
</div></body></html>