Home

Dynamically update metadata from a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-207805%22%20slang%3D%22en-US%22%3EDynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-207805%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20excel%20I've%20created%20a%20link%20between%20a%20cell%20and%20custom%20properties.%3CBR%20%2F%3EThe%20value%20is%20dynamically%20updated%20in%26nbsp%3B%20custom%20properties%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20381px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36651iA006E57DB4724348%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%2201.png%22%20title%3D%2201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20ever%20it%20is%20only%20created%20once%20in%20the%20files%20metadata%20and%20it%20does%20not%20update%20when%20saving%20the%20document%20or%20make%20any%20changes%20in%20the%20cell.%2028%2C57%25%20was%20the%20first%20value%20created%20from%20the%20linked%20cell%2C%20the%20value%20in%20the%20cell%20has%20now%20changed%20to%2014%2C28%20%25%20in%20custom%20properties%20but%20is%20not%20updated%20in%20the%20metadata%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20758px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36652iCADA4F8BDD3430FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%2202.png%22%20title%3D%2202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20to%20act%20the%20same%20way%20as%20the%20%22Size%22%20does.%20I%20want%20to%20use%20the%20metadata%20in%20a%20column%20in%20sharepoint%20which%20shows%20the%20status%20in%20a%20project%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F36654i285534781EE53F45%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%2204.png%22%20title%3D%2204.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20someone%20able%20to%20help%20me%20out%20here%20%3A)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EEmil%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-207805%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389976%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F143856%22%20target%3D%22_blank%22%3E%40Emil%20Rindell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Emil%2C%3C%2FP%3E%3CP%3Eit%26nbsp%3B%20is%20part%20of%20my%26nbsp%3B%20macro%20%2C%20may%20be%20your%20college%20will%20use%20it%20to%20help%20you.%20(%20Sorry%2C%20Cyrillic%20letters%26nbsp%3B%20will%20not%20proper%20print%20in%20those%20site%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESub%20%C3%8C%C3%A0%C3%AA%C3%B0%C3%AE%C3%B11()%3C%2FP%3E%3CP%3ESheets(%22%C3%87%C3%A0%C3%AF%C3%B0%C3%AE%C3%B1%22).Activate%3CBR%20%2F%3EDim%20a%20As%20String%3CBR%20%2F%3Ea%20%3D%20Cells(3%2C%203)%3CBR%20%2F%3EActiveWorkbook.ContentTypeProperties(%22%C3%87%C3%A0%C3%BF%C3%A2%C3%A8%C3%B2%C3%A5%C3%AB%C3%BC%22).Value%20%3D%20a%3CBR%20%2F%3EDim%20b%20As%20String%3CBR%20%2F%3Eb%20%3D%20Cells(4%2C%203)%3CBR%20%2F%3EActiveWorkbook.ContentTypeProperties(%22%C3%8D%C3%A0%C3%A8%C3%AC%C3%A5%C3%AD%C3%AE%C3%A2%C3%A0%C3%AD%C3%A8%C3%A5%22).Value%20%3D%20b%3CBR%20%2F%3EDim%20c%20As%20String%3CBR%20%2F%3Ec%20%3D%20Cells(5%2C%203)%3CBR%20%2F%3EActiveWorkbook.ContentTypeProperties(%22%C3%93%C3%B7%C3%A0%C3%B1%C3%B2%C3%AE%C3%AA%22).Value%20%3D%20c%3CBR%20%2F%3EDim%20d%20As%20String%3CBR%20%2F%3Ed%20%3D%20Cells(5%2C%209)%3CBR%20%2F%3EActiveWorkbook.ContentTypeProperties(%22%C3%87%C3%AE%C3%AD%C3%A0%22).Value%20%3D%20d%3CBR%20%2F%3EDim%20e%20As%20String%3CBR%20%2F%3Ee%20%3D%20Cells(7%2C%202)%3CBR%20%2F%3EActiveWorkbook.ContentTypeProperties(%22%C3%8E%C3%AF%C3%A8%C3%B1%C3%A0%C3%AD%C3%A8%C3%A5%22).Value%20%3D%20e%3CBR%20%2F%3EDim%20g%20As%20String%3CBR%20%2F%3Eg%20%3D%20Cells(9%2C%202)%3CBR%20%2F%3EActiveWorkbook.ContentTypeProperties(%22%C3%8F%C3%B0%C3%A8%C3%B7%C3%A8%C3%AD%C3%A0%22).Value%20%3D%20g%3CBR%20%2F%3ERange(%22AL65%3AAP78%22).Select%3CBR%20%2F%3EActiveWindow.SmallScroll%20Down%3A%3D-9%3CBR%20%2F%3ESelection.Copy%3CBR%20%2F%3EActiveWindow.SmallScroll%20Down%3A%3D-27%3CBR%20%2F%3ERange(%22AL38%22).Select%3CBR%20%2F%3ESelection.PasteSpecial%20Paste%3A%3DxlPasteValues%2C%20Operation%3A%3DxlNone%2C%20SkipBlanks%20_%3CBR%20%2F%3E%3A%3DFalse%2C%20Transpose%3A%3DFalse%3CBR%20%2F%3EActiveWindow.SmallScroll%20Down%3A%3D18%3CBR%20%2F%3ERange(%22AL60%3AAN60%22).Select%3CBR%20%2F%3EApplication.CutCopyMode%20%3D%20False%3CBR%20%2F%3ESelection.Copy%3CBR%20%2F%3ERange(%22%C3%92%C3%A0%C3%A1%C3%AB%C3%A8%C3%B6%C3%A02%5B%C3%A8%C3%AD%C3%A8%C3%B6%C3%A8%C3%A0%C3%B2%C3%AE%C3%B0%5D%22).Select%3CBR%20%2F%3ESelection.PasteSpecial%20Paste%3A%3DxlPasteValues%2C%20Operation%3A%3DxlNone%2C%20SkipBlanks%20_%3CBR%20%2F%3E%3A%3DFalse%2C%20Transpose%3A%3DFalse%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-389963%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-389963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F308428%22%20target%3D%22_blank%22%3E%40Mudskipper%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20answer.%20Sorry%20no%20I%20haven't%20solved%20this%20issue%20yet.%20A%20colleuge%20of%20mine%20(wich%20have%20great%20skills%20in%20excel)%20tried%20this%20as%20well%20without%20any%20success.%20I'm%20guess%20that%20the%20issue%20is%20related%20to%20Sharepoint%20Online.%20However%20this%20could%20might%20be%20solved%20using%20Microsoft%20Flow%20but%20i'm%20not%20sure.%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20you%20find%20a%20solution%20to%20this.%20Or%20if%20I'm%20able%20to%20solve%20it%20I%20will%20post%20it%20in%20this%20thread.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388923%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388923%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20the%20exact%20same%20issues%20with%20something%20I%20am%20looking%20to%20do!%26nbsp%3B%20%3CSPAN%3EI%20am%20looking%20to%20populate%20excel%20file%20metadata%20in%20SharePoint%20365%20from%20specific%20cells%20within%20the%20excel%20file.%20I%20am%20able%20to%20create%20the%20linked%20Advanced%20Properties%20within%20the%20file%2C%20import%20it%20into%20SharePoint%2C%20and%20auto%20populate%20the%20values%20on%20the%20initial%20load.%20The%20problem%20is%2C%20when%20users%20update%20the%20information%20in%20the%20linked%20cell%20it%20shows%20in%20the%20Properties%20setup%20window%2C%20but%20not%20in%20the%20Advanced%20Properties%20dropdown%20(on%20Info%20screen).%20It%20seems%20like%20this%20is%20only%20ever%20updated%20once%20and%20I%20can't%20seem%20to%20get%20it%20to%20refresh.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EUtilizing%20VBA%20I%20was%20able%20to%20view%20these%20properties%20and%20could%20see%20that%20they%20were%20stored%20correctly%2C%20but%20it%20was%20not%20updating%20the%20Advanced%20Properties%20dropdown.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EVBA%20used%20to%20check%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3Erw%20%3D%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E1%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E%26nbsp%3BWorksheets(%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E1%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E).Activate%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%230101FD%22%3E%3CSPAN%3EFor%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%230101FD%22%3E%3CSPAN%3EEach%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E%26nbsp%3Bp%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%230101FD%22%3E%3CSPAN%3EIn%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E%26nbsp%3BActiveWorkbook.CustomDocumentProperties%20Cells(rw%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E1%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E).Value%20%3D%20p.Name%20Cells(rw%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E2%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E).Value%20%3D%20p.Value%20rw%20%3D%20rw%20%2B%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23000000%22%3E%3CSPAN%3E1%3C%2FSPAN%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%230101FD%22%3E%3CSPAN%3ENext%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20you%20have%20solved%20this%20issue.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F143856%22%20target%3D%22_blank%22%3E%40Emil%20Rindell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352569%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352569%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20data%20in%20cell%20filled%20by%20formula%20it%20not%20update.%20Create%20macro%20in%20order%20to%20fill%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309619%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309619%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261110%22%20target%3D%22_blank%22%3E%40harbak%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20but%20no%20I%20tried%20all%20kinds%20of%20workarounds%20but%20in%20the%20end%20I%20did%20not%20got%20this%20to%20work%20as%20I%20wanted.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20been%20thinking%20of%20using%20Flow%20to%20solve%20it%2C%20but%20have%20not%20tried%20anything%20yet%20due%20to%20lack%20of%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20you're%20able%20to%20find%20a%20solution%20to%20this!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309562%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309562%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F143856%22%20target%3D%22_blank%22%3E%40Emil%20Rindell%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EI%20have%20also%20tried%20this%2C%20but%20had%20the%20same%20problem%20as%20you%20with%20the%20properties%20not%20updating.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDid%20you%20find%20a%20solution%20for%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210324%22%20slang%3D%22en-US%22%3ERe%3A%20Dynamically%20update%20metadata%20from%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210324%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Emil-%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20seems%20odd.%26nbsp%3B%20I%20wonder%20if%20the%20data%20on%20SharePoint%20is%20refreshing%20properly.%26nbsp%3B%20Will%20the%20value%20update%20if%20the%20Custom%20Property%20is%20hardcoded%3F%26nbsp%3B%20If%20so%20you%20may%20be%20able%20to%20use%20a%20worksheet%20change%20event%20to%20update%20the%20value%20or%20perhaps%20a%20button%20with%20a%20macro%20linked%20to%20it.%26nbsp%3B%20You%20may%20test%20this%20file%26nbsp%3B(see%20attached)%20and%20see%20if%20that%20will%20work%20for%20your%20scenario.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20linked%20custom%20property%20doesn't%20update%20then%20it%20would%20be%20kind%20of%20useless.%26nbsp%3B%20Seems%20kind%20of%20glitchy%20if%20that's%20the%20case.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EChange%20Event%20Macro%3A%3C%2FP%3E%0A%3CPRE%3EPrivate%20Sub%20Worksheet_Change(ByVal%20Target%20As%20Range)%0A%0A%20%20%20%20If%20Target.Address%20%3D%20Range(%22rngProcent%22).Address%20Then%0A%20%20%20%20'Update%20the%20value%20of%20the%20hardcoded%20custom%20property%20to%20match%20that%20of%0A%20%20%20%20'the%20linked%20custom%20property....%0A%20%20%20%20ActiveWorkbook.CustomDocumentProperties(%22Procent%22).Value%20%3D%20Range(%22rngProcent1%22)%0A%20%20%20%20End%20If%0A%0AEnd%20Sub%0A%0A%3C%2FPRE%3E%0A%3CP%3EButton%20Macro%3A%3C%2FP%3E%0A%3CPRE%3ESub%20Rectangle1_Click()%0A%20%20%20ActiveWorkbook.CustomDocumentProperties(%22Procent_1%22).Value%20%3D%20Range(%22rngProcent1%22)%0AEnd%20Sub%0A%0A%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Emil Rindell
Occasional Contributor

Hi,

 

In excel I've created a link between a cell and custom properties.
The value is dynamically updated in  custom properties:

 

01.png

 

How ever it is only created once in the files metadata and it does not update when saving the document or make any changes in the cell. 28,57% was the first value created from the linked cell, the value in the cell has now changed to 14,28 % in custom properties but is not updated in the metadata: 

 

02.png

 

I want it to act the same way as the "Size" does. I want to use the metadata in a column in sharepoint which shows the status in a project:

 

04.png

 

Is someone able to help me out here :)?

 

Regards,

Emil

7 Replies

Hey Emil-

 

This seems odd.  I wonder if the data on SharePoint is refreshing properly.  Will the value update if the Custom Property is hardcoded?  If so you may be able to use a worksheet change event to update the value or perhaps a button with a macro linked to it.  You may test this file (see attached) and see if that will work for your scenario.

 

If the linked custom property doesn't update then it would be kind of useless.  Seems kind of glitchy if that's the case.

 

Change Event Macro:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Address = Range("rngProcent").Address Then
    'Update the value of the hardcoded custom property to match that of
    'the linked custom property....
    ActiveWorkbook.CustomDocumentProperties("Procent").Value = Range("rngProcent1")
    End If

End Sub

Button Macro:

Sub Rectangle1_Click()
   ActiveWorkbook.CustomDocumentProperties("Procent_1").Value = Range("rngProcent1")
End Sub

 

 

Hi @Emil Rindell,

I have also tried this, but had the same problem as you with the properties not updating.

 

Did you find a solution for this problem?

Hi @harbak,

 

Sorry, but no I tried all kinds of workarounds but in the end I did not got this to work as I wanted. 

I been thinking of using Flow to solve it, but have not tried anything yet due to lack of time. 

 

Please let me know if you're able to find a solution to this! 

If data in cell filled by formula it not update. Create macro in order to fill cell.

I found the exact same issues with something I am looking to do!  I am looking to populate excel file metadata in SharePoint 365 from specific cells within the excel file. I am able to create the linked Advanced Properties within the file, import it into SharePoint, and auto populate the values on the initial load. The problem is, when users update the information in the linked cell it shows in the Properties setup window, but not in the Advanced Properties dropdown (on Info screen). It seems like this is only ever updated once and I can't seem to get it to refresh.

Utilizing VBA I was able to view these properties and could see that they were stored correctly, but it was not updating the Advanced Properties dropdown.

VBA used to check:
rw = 1 Worksheets(1).Activate ForEach p In ActiveWorkbook.CustomDocumentProperties Cells(rw, 1).Value = p.Name Cells(rw, 2).Value = p.Value rw = rw + 1Next

 

 

Please let me know if you have solved this issue.

@Emil Rindell 

@Mudskipper 

 

Hi,

 

Thanks for your answer. Sorry no I haven't solved this issue yet. A colleuge of mine (wich have great skills in excel) tried this as well without any success. I'm guess that the issue is related to Sharepoint Online. However this could might be solved using Microsoft Flow but i'm not sure.

Please let me know if you find a solution to this. Or if I'm able to solve it I will post it in this thread.   

@Emil Rindell 

Hi Emil,

it  is part of my  macro , may be your college will use it to help you. ( Sorry, Cyrillic letters  will not proper print in those site

 

Sub Ìàêðîñ1()

Sheets("Çàïðîñ").Activate
Dim a As String
a = Cells(3, 3)
ActiveWorkbook.ContentTypeProperties("Çàÿâèòåëü").Value = a
Dim b As String
b = Cells(4, 3)
ActiveWorkbook.ContentTypeProperties("Íàèìåíîâàíèå").Value = b
Dim c As String
c = Cells(5, 3)
ActiveWorkbook.ContentTypeProperties("Ó÷àñòîê").Value = c
Dim d As String
d = Cells(5, 9)
ActiveWorkbook.ContentTypeProperties("Çîíà").Value = d
Dim e As String
e = Cells(7, 2)
ActiveWorkbook.ContentTypeProperties("Îïèñàíèå").Value = e
Dim g As String
g = Cells(9, 2)
ActiveWorkbook.ContentTypeProperties("Ïðè÷èíà").Value = g
Range("AL65:AP78").Select
ActiveWindow.SmallScroll Down:=-9
Selection.Copy
ActiveWindow.SmallScroll Down:=-27
Range("AL38").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWindow.SmallScroll Down:=18
Range("AL60:AN60").Select
Application.CutCopyMode = False
Selection.Copy
Range("Òàáëèöà2[èíèöèàòîð]").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies