[Hidden-tech] Google Sheets Question

[dlesser at ptraining.com]

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. 

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.

On 2019-06-26 9:28 am, Garth Shaneyfelt wrote:

> Provided they are familiar with Excel (and sharing and formulas...etc).  In my experience, people can mess those up pretty well too! 
> 
> -Garth Shaneyfelt
> Let's Create a Better World 
> 
> On Wednesday, June 26, 2019, 11:18:01 AM EDT, Marla Michel via Hidden-discuss <hidden-discuss at lists.hidden-tech.net> wrote: 
> 
> Excel online on OneDrive (for any operating system) enables multiple people to share/access/update workbooks online and skip the unfamiliar Google Sheets quirks. 
> 
> Excel: https://office.live.com/start/Excel.aspx 
> OneDrive: https://onedrive.live.com/ 
> Tutorial: https://www.excel-easy.com/examples/onedrive.html 
> 
> Marla 
> 
> On Wed, Jun 26, 2019 at 5:11 AM dlesser--- via Hidden-discuss <hidden-discuss at lists.hidden-tech.net> wrote: 
> 
> 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.
> 
> On 2019-06-26 6:05 am, dlesser at ptraining.com wrote: 
> 
> A question for the group. 
> 
> 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. 
> 
> 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. 
> 
> 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. 
> 
> 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. 
> 
> 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. 
> 
> Any suggestions would be appreciated. _______________________________________________
> Hidden-discuss mailing list - home page: http://www.hidden-tech.net
> Hidden-discuss at lists.hidden-tech.net
> 
> You are receiving this because you are on the Hidden-Tech Discussion list.
> If you would like to change your list preferences, Go to the Members
> page on the Hidden Tech Web site.
> http://www.hidden-tech.net/members

_______________________________________________
Hidden-discuss mailing list - home page: http://www.hidden-tech.net
Hidden-discuss at lists.hidden-tech.net

You are receiving this because you are on the Hidden-Tech Discussion
list.
If you would like to change your list preferences, Go to the Members
page on the Hidden Tech Web site.
http://www.hidden-tech.net/members
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.hidden-tech.net/pipermail/hidden-discuss/attachments/20190626/cb47fb35/attachment.html>