ISO 9001:2015 - Is control possible with Excel adaptable measurement sheets?

Miner

Forum Moderator
Staff member
Admin
#11
I cannot duplicate your issue. However, I am using Office 365 Excel, so they may have fixed the issue.
 
Elsmar Forum Sponsor

Ninja

Looking for Reality
Staff member
Super Moderator
#12
When I drag the number "2" from D5 down to E10: (Not copy/paste...but drag and drop)

The total in G5 remains "10" since the formula has changed.
Also, the cell G10 now shows "#REF!" since I dropped a cell reference in place of one of the formula components.

You see something different?
 

Miner

Forum Moderator
Staff member
Admin
#13
Got it. You are grabbing it on an edge with the 4-way arrow, not with the + sign in the lower right corner. That does duplicate your issue.
 

Miner

Forum Moderator
Staff member
Admin
#14
This work-around (uncheck the box in red) prevents the issue. Unfortunately, it does not travel with the file, but stays with the specific copy of Excel. In other words, I can configure my copy of Excel to prevent it, but if I send the file to you, you can still drag and drop unless you configure your copy of Excel in the same way.

I did find the attached VBA code to do the same. Not being a macro/VBA expert, I don't know if you can embed this in a specific file to turn it off when the file is opened, and turn it back on when the file is closed.

I also found this that might work for you.

This site was more helpful.
.
 

Attachments

Last edited:

Ninja

Looking for Reality
Staff member
Super Moderator
#16
Did not enable macros (never worked anywhere that allowed it...including here in my company)...but without enabling the macro, it looks like it prevents the drag in the first place.
Unfortunately, it also prohibits copy/cut/paste.

I'll try it out on a different non-net computer after I do a full backup...nothing personal, but what are security measures for if the boss ignores them...:nope:

Had a sever infected once...55 people sitting on their butts for a week, and three weeks of work lost (worm got the backups too...had to rewind to start of month backup).
Funny, I stepped into Director of IT role within a year after that :cool:

All the same, I appreciate the potential work-around. Consider posting it to the downloads section on here.
 

Ninja

Looking for Reality
Staff member
Super Moderator
#17
Got it. You are grabbing it on an edge with the 4-way arrow, not with the + sign in the lower right corner. That does duplicate your issue.
- We would run 5-10 parts on a CMM for length and 3 width measurements, fire the part, then measure the parts again.
- Data came out in .csv file (Vertex did not export to XL).
- We then opened the .csv in XL and used copy/paste to put the data into the calc spreadsheet for firing shrinkage.

it is easier to drop the data block, then move it to where it was needed than to copy/paste each of 10 lines...that's how I found this flaw.

In the end, I would rebuild the spreadsheet around the data format of the .csv so it was only one copy/paste to avoid the dragging...and rather pointed discussions during training about data integrity...with a few repeats of "Thou shalt not drag lest you die".

Typo's were the #1 cause of measurement error from a CMM...copy paste solved it...with the weakness of drag/drop ever present.
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#19
I agree that protecting formula cells is not a perfect control. It is worth checking occasionally to see if the data are being made unreliable. It may be considered a reasonable control nonetheless, just as is saving a scanned document as a .pdf when a person can use Adobe's Professional edit feature and change text...
 
Thread starter Similar threads Forum Replies Date
Q ISO 9001-2015 Internal audit finding Internal Auditing 12
R AS9100D internal audit checklist or ISO 9001 2015 to AS9100 D AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
J Opportunity in ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 27
D Reports under change management | ISO 13485:2016 & ISO 9001:2015 ISO 13485:2016 - Medical Device Quality Management Systems 3
K Integrating ISO 9001:2015 with ISO 17025:2017 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
S Sequence of ISO 9001:2015 Implementation Steps ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Brizilla Employee Data Privacy Policy - ISO 9001:2015 requirement(s)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
S ISO 9001:2015 Internal Auditing Internal Auditing 8
Q Process: Knowledge Section 7.1.6 of ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
A What must be recorded? (ISO 9001:2015, subclause 10.2) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
S ISO 9001:2015 vs 21 CFR Part 211 matrix Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
M Does the ISO 9001:2015 standard require a disaster recovery plan or emergency response plan ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16
M ISO 9001:2015 and AS6081:2012 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
C Implementation ISO 9001: 2015 ? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
eule del ayre Documented Information - Periodic Review of Documents? IATF 16949:2016 / ISO 9001:2015 IATF 16949 - Automotive Quality Systems Standard 34
J Audit Checklist for Integrated Management System for ISO 9001:2015, ISO 14001 & OHSAS18001 (IMS) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
lanley liao How to understand the clause 6 Planning of ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
A Does ISO 9001:2015 cover all the requirements of ISO 10012:2003? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
T ISO 9001:2015 - Small Shop ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
M ISO 9001:2015 case study sample ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
M Sample of Nonconformity report for ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
M Case study help as per ISO 9001: 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 18
M Case study solution help required as per ISO 9001 : 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
F Logistics and IT clauses in ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 15
V Quality Objectives - ISO 9001 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 26
Gun46 ISO 9001 : 2015 Lead Auditor Exam General Auditing Discussions 16
Q ISO 9001:2015 man days for surveillance audit ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
D ISO 9001:2015 4.3 Determining the Scope of the QMS ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
I ISO 9001:2015 Section 9.3.2 C1 "customer satisfaction and feedback from relevant interested parties" ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
I ISO-9001:2015 and "Relevant Parties" Management Review Meetings and related Processes 2
I Master Document Access - ISO 9001:2015 clause 7.5.3 Document Control Systems, Procedures, Forms and Templates 5
qualprod Why new clause (7.1.6) in ISO 9001:2015? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
I Where can I beg, steal (just kidding of course) or borrow good training material on the ISO 9001:2015 standard? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
Robert Stanley Which Registrar Should I Choose for ISO 9001:2015 registration? Registrars and Notified Bodies 10
M ISO 9001:2015 8.2.1 Contingency Plan required for small Business? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
A Help with Drawing Review - ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
V ISO 9001:2015 7.2 Competence ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 35
B ISO 9001:2015 Transition: Much Easier Than You Think! Misc. Quality Assurance and Business Systems Related Topics 0
A Process Documentation for ISO 9001:2015 Internal Auditing 2
C Migrate ISO 9001:2015 Certificate Registrars and Notified Bodies 4
J ISO 9001:2015 Small Operation Management Review General Auditing Discussions 6
E Three basic questions about ISO 9001:2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
C ISO 9001:2015 Monitoring and measuring resources. Application a service industry ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
W ISO 9001:2015 Management Review Input Template wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 1
G Is ISO 9001:2015 certification worth it for a company that does only contract manufacturing? Quality Management System (QMS) Manuals 14
N ISO 9001:2015 Customer Complaints Requirements ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
O Performance Measurement ISO 9001: 2015 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
C Does ISO 9001-2015 have a requirement for manufacturing equipment to be numbered? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
V ISO 9001: 2015 Production drawing Control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
KCalaba21 ISO 9001:2015 6.2.2 E - "e) how the results will be evaluated." ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3

Similar threads

Top Bottom