{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CustomerUpdate","Instructions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CustomerUpdate","index":0,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["_P00 [Production]","KUNNR","VKORG","VTWEG","SPART","KNVV-LOEVM","KNVV-AUFSD","KNVV-LIFSD","KNVV-FAKSD"]

{"sheet":"Instructions","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Start by changing the value in cell A1 on the CustomerUpdate tab to the Name of the server to which this tool will connect.  This is how the VBA code knows in which server the data will be loaded.   \n\nWhen trying to update fields that exist in both KNA1 and KNVV, be sure to use the whole name of the field as the column header.  If just the name of the field without the name of the table is supplied then the tool will try to update both fields.  Fields that only exist in KNVV are fine to have just the name of the field as the column header. \n\nThis tool will not touch fields in KNA1 that also exist in KNVV like AUFSD, LIFSD, FAKSD and LOEVM. Code was added in February of 2023 so that these are not set in \"All Sales Areas\" fields, but only in the specified Sales Area. \n\nThe ability to touch the deletion flag and set blocks in KNA1 can be added back in.  The line in the middle of TouchFields function can be modified to allow access to KNA1 fields. \n\nThis tool comes with no warranty, expressed or implied.  Always test thoroughly in a sandbox to ensure that the tool is doing what is desired. "]