<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Alex, thanks so much. The version history showed when the changes happened and who made them. (Inadvertent dragging was the culprit, which I suspected but couldn’t document.) Hopefully, some education will solve the issue.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Can’t thank you enough. And thanks to everyone who replied. Once again, the Hidden-Tech community rallied to help. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Don Lesser<o:p></o:p></p><p class=MsoNormal>139B Damon Road<o:p></o:p></p><p class=MsoNormal>Northampton, MA 01060<o:p></o:p></p><p class=MsoNormal><a href="mailto:dlesser@ptraining.com"><span style='color:#0563C1'>dlesser@ptraining.com</span></a><o:p></o:p></p><p class=MsoNormal>413 387-1040<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><b>From:</b> Alex at Just Peachy <alex@justpeachy.io> <br><b>Sent:</b> Wednesday, June 26, 2019 1:30 PM<br><b>To:</b> dlesser@ptraining.com<br><b>Cc:</b> Garth Shaneyfelt <gshaneyfelt@yahoo.com>; Hidden-Tech Tech <hidden-discuss@lists.hidden-tech.net><br><b>Subject:</b> Re: [Hidden-tech] Google Sheets Question<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Could you dig through the document <a href="https://support.google.com/docs/answer/190843?co=GENIE.Platform%3DDesktop&hl=en">revision history</a> to see when the changes happened? You should be able to see what was changed and by who.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Best,<o:p></o:p></p></div><div><p class=MsoNormal>Alex<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Alex Martines<o:p></o:p></p></div><div><p class=MsoNormal>Just Peachy Web Design<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>On Wed, Jun 26, 2019 at 1:09 PM dlesser--- via Hidden-discuss <<a href="mailto:hidden-discuss@lists.hidden-tech.net">hidden-discuss@lists.hidden-tech.net</a>> wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'>Thanks for the suggestions. Excel On-Line doesn't allow macros and has some other limits to functionality that might preclude its use. I will look into forms, though I will need to be able to load previous data as well as look at and enter this week's.<o:p></o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'>Still looking to see whether anyone has run into Google Sheets quirks that can cause this behavior. I don't like to be blaming my clients unless I am clear that they are causing the problem. Usually, I can educate them, but this particular one is hard--if they are causing the problem, they are not aware of it and so it is hard to suggest modifications to their behavior.<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'> <o:p></o:p></span></p></div><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'><o:p> </o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif'>On 2019-06-26 9:28 am, Garth Shaneyfelt wrote:<o:p></o:p></span></p><blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 5.0pt;margin-left:0in;margin-right:0in'><div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'>Provided they are familiar with Excel (and sharing and formulas...etc). In my experience, people can mess those up pretty well too!<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'> <o:p></o:p></span></p></div><div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'>-Garth Shaneyfelt<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'>Let's Create a Better World<o:p></o:p></span></p></div></div></div></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica",sans-serif'> <o:p></o:p></span></p></div></div><div id="gmail-m_-7723591193435645656ydp50eb4aceyahoo_quoted_1686572179"><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Wednesday, June 26, 2019, 11:18:01 AM EDT, Marla Michel via Hidden-discuss <<a href="mailto:hidden-discuss@lists.hidden-tech.net" target="_blank">hidden-discuss@lists.hidden-tech.net</a>> wrote:<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'> <o:p></o:p></span></p></div><div><div id="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053"><div><div><div><div><div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Excel online on OneDrive (for any operating system) enables multiple people to share/access/update workbooks online and skip the unfamiliar Google Sheets quirks.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Excel: <a href="https://office.live.com/start/Excel.aspx" target="_blank">https://office.live.com/start/Excel.aspx</a><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>OneDrive: <a href="https://onedrive.live.com/" target="_blank">https://onedrive.live.com/</a><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Tutorial: <a href="https://www.excel-easy.com/examples/onedrive.html" target="_blank">https://www.excel-easy.com/examples/onedrive.html</a><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'> <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>Marla<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'> <o:p></o:p></span></p></div></div></div></div></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'><o:p> </o:p></span></p><div><div id="gmail-m_-7723591193435645656ydp50eb4aceyiv4539955053yqt96440"><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>On Wed, Jun 26, 2019 at 5:11 AM dlesser--- via Hidden-discuss <<a href="mailto:hidden-discuss@lists.hidden-tech.net" target="_blank">hidden-discuss@lists.hidden-tech.net</a>> wrote:<o:p></o:p></span></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>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.<o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'> <o:p></o:p></span></p></div><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'><o:p> </o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>On 2019-06-26 6:05 am, <a href="mailto:dlesser@ptraining.com" target="_blank">dlesser@ptraining.com</a> wrote:<o:p></o:p></span></p><blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0in 0in 0in 5.0pt;margin-left:0in;margin-right:0in'><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>A question for the group.<o:p></o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>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.<o:p></o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>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.<o:p></o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>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.<o:p></o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>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.<o:p></o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>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.<o:p></o:p></span></p><p><span style='font-size:12.0pt;font-family:"Verdana",sans-serif;color:#26282A'>Any suggestions would be appreciated.<o:p></o:p></span></p></blockquote></div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>_______________________________________________<br>Hidden-discuss mailing list - home page: <a href="http://www.hidden-tech.net" target="_blank">http://www.hidden-tech.net</a><br><a href="mailto:Hidden-discuss@lists.hidden-tech.net" target="_blank">Hidden-discuss@lists.hidden-tech.net</a><br><br>You are receiving this because you are on the Hidden-Tech Discussion list.<br>If you would like to change your list preferences, Go to the Members<br>page on the Hidden Tech Web site.<br><a href="http://www.hidden-tech.net/members" target="_blank">http://www.hidden-tech.net/members</a><o:p></o:p></span></p></blockquote></div></div></div></div><div id="gmail-m_-7723591193435645656ydp50eb4aceyqt51534"><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A'>_______________________________________________<br>Hidden-discuss mailing list - home page: <a href="http://www.hidden-tech.net" target="_blank">http://www.hidden-tech.net</a><br><a href="mailto:Hidden-discuss@lists.hidden-tech.net" target="_blank">Hidden-discuss@lists.hidden-tech.net</a><br><br>You are receiving this because you are on the Hidden-Tech Discussion list.<br>If you would like to change your list preferences, Go to the Members<br>page on the Hidden Tech Web site.<br><a href="http://www.hidden-tech.net/members" target="_blank">http://www.hidden-tech.net/members</a><o:p></o:p></span></p></div></div></div></div></blockquote></div><p class=MsoNormal>_______________________________________________<br>Hidden-discuss mailing list - home page: <a href="http://www.hidden-tech.net" target="_blank">http://www.hidden-tech.net</a><br><a href="mailto:Hidden-discuss@lists.hidden-tech.net" target="_blank">Hidden-discuss@lists.hidden-tech.net</a><br><br>You are receiving this because you are on the Hidden-Tech Discussion list.<br>If you would like to change your list preferences, Go to the Members<br>page on the Hidden Tech Web site.<br><a href="http://www.hidden-tech.net/members" target="_blank">http://www.hidden-tech.net/members</a><o:p></o:p></p></blockquote></div></div></div></body></html>