Greyed formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1591543%22%20slang%3D%22en-US%22%3EGreyed%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591543%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20got%20a%20problem%20w%20a%20ss%20used%20for%20many%20years...can't%20find%20the%20solution...problem%20is%20associated%20w%20changes%20to%20formatting%20of%20cells...specifically%20the%20Borders%2C%20Fill%20and%20Font%20options...when%20i%20try%20to%20make%20a%20change%20the%20drop%20down%20menu%20is%20greyed%20and%20the%20options%20cannot%20be%20used...any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1591543%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591593%22%20slang%3D%22de-DE%22%3ESubject%3A%20Greyed%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591593%22%20slang%3D%22de-DE%22%3EIt%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20So%20you%20could%20get%20a%20precise%20solution%20much%20faster.%20This%20would%20also%20be%20a%20blessing%20for%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20can%20only%20guess%20that%20there%20is%20no%20Excel%20file%20(and%20I'm%20not%20good%20at%20that).%20Suspect%20because%20the%20translation%20of%20your%20request%20sometimes%20also%20plays%20a%20role.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Your%20case%20could%20be%20anything%20from%20data%20validation%20errors%20to%20background%20macros%20and%20worksheet.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20would%20therefore%20be%20happy%20to%20be%20able%20to%20help%20you%20if%20you%20would%20provide%20us%20with%20the%20worksheet%20(without%20sensitive%20data).%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1593034%22%20slang%3D%22en-US%22%3ERe%3A%20Greyed%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F761064%22%20target%3D%22_blank%22%3E%40rer555%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20piece%20of%20the%20file%20exhibiting%20the%20problem...TESTfile.xlsx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1593483%22%20slang%3D%22de-DE%22%3ERe%3A%20Greyed%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593483%22%20slang%3D%22de-DE%22%3ECells%20C4%3A%20C7%20get%20their%20data%20from%20java%20script%20D13.%20But%20this%20is%20not%20accessible%20(cannot%20be%20executed)%20for%20the%20file%2C%20hence%20the%20reference%20error.%20The%20error%20in%20turn%20extends%20to%20D4%3A%20D6.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20It%20is%20a%20worksheet%20that%20could%20come%20from%20a%20community%20file%20(such%20as%20a%20workbook%20for%20the%20whole%20team%20in%20OneDrive)%20that%20is%20distributed%20to%20the%20users%20depending%20on%20their%20authorization.%20However%2C%20the%20probability%20is%20that%20the%20data%20from%20an%20XML%20file%20is%20distributed%20from%20the%20sharepoint%20or%20that%20the%20user%20has%20access.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Unfortunately%2C%20I%20can't%20help%20you%20with%20this%2C%20an%20expert%20who%20is%20familiar%20with%20java%20scripts%20would%20have%20to%20look%20at%20it%20and%20clearly%20define%20the%20error%2C%20even%20if%20it%20can%20solve%20it.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20wish%20you%20a%20speedy%20solution%20or%20a%20clear%20definition%20of%20your%20options.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Have%20a%20good%20time.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1594436%22%20slang%3D%22en-US%22%3ERe%3A%20Greyed%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1594436%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20response...I've%20no%20idea%20how%20the%20code%20got%20there%2C%20but%20when%20it%20executed%2C%20it%20was%20producing%20sales%20info%20on%20MS%20products...however%2C%20per%20your%20input%20i%20was%20able%20to%20noodle%20around%20and%20found%20a%20fix...1st%20was%20to%20clear%20the%20code%20from%20the%20cell%3B%202nd%20was%20to%20cut%20the%20symbols%2C%20one%20at%20a%20time%2C%20and%20move%20them%20to%20a%20fresh%20ss...when%20all%20of%20the%20symbols%20had%20been%20moved%20to%20the%20new%20ss%2C%20i%20then%20deleted%20the%20new%20sheet...and%20voila'%20my%20original%20sheet%20no%20longer%20had%20the%20symbols%20or%20the%20issue...thx%20again%20for%20your%20input%20on%20the%20issue...%3C%2FP%3E%3CP%3ERay%20R%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1596264%22%20slang%3D%22de-DE%22%3ERe%3A%20Greyed%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1596264%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F761064%22%20target%3D%22_blank%22%3E%40rer555%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22text-wrap%20tlid-copy-target%22%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EI%20was%20very%20pleased%20that%20my%20cell%20found%20and%20initiated%20you%20were%20able%20to%20solve%20the%20problem%20yourself.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EIf%20the%20problem%20is%20solved%20for%20you%2C%20you%20would%20please%20click%20this%20as%20the%20correct%20answer%20and%20if%20possible%20a%20like%20(click%20thumbs%20up).%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThus%2C%20the%20following%20can%20see%20that%20the%20problem%20no%20longer%20exists%20and%20may%20also%20use%20it%20as%20an%20approach%20to%20a%20solution.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20in%20advance%20for%20your%20understanding%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EI%20wish%20you%20a%20pleasant%20day%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22result-shield-container%20tlid-copy-target%22%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22tlid-result-transliteration-container%20result-transliteration-container%20transliteration-container%22%3E%3CDIV%20class%3D%22tlid-transliteration-content%20transliteration-content%20full%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

I've got a problem w a ss used for many years...can't find the solution...problem is associated w changes to formatting of cells...specifically the Borders, Fill and Font options...when i try to make a change the drop down menu is greyed and the options cannot be used...any ideas?

5 Replies
It can help us all if you upload an Excel file (without sensitive data), no picture. So you could get a precise solution much faster. This would also be a blessing for us, as we can understand the problem much better, a win-win situation for everyone.

I can only guess that there is no Excel file (and I'm not good at that). Suspect because the translation of your request sometimes also plays a role.

Your case could be anything from data validation errors to background macros and worksheet.

I would therefore be happy to be able to help you if you would provide us with the worksheet (without sensitive data).

Nikolino
I know I don't know anything (Socrates)

@rer555 

Here's a piece of the file exhibiting the problem...TESTfile.xlsx

Cells C4: C7 get their data from java script D13. But this is not accessible (cannot be executed) for the file, hence the reference error. The error in turn extends to D4: D6.

It is a worksheet that could come from a community file (such as a workbook for the whole team in OneDrive) that is distributed to the users depending on their authorization. However, the probability is that the data from an XML file is distributed from the sharepoint or that the user has access.

Unfortunately, I can't help you with this, an expert who is familiar with java scripts would have to look at it and clearly define the error, even if it can solve it.

I wish you a speedy solution or a clear definition of your options.

Have a good time.

Nikolino
I know I don't know anything (Socrates)

@Nikolino 

Thank you for the response...I've no idea how the code got there, but when it executed, it was producing sales info on MS products...however, per your input i was able to noodle around and found a fix...1st was to clear the code from the cell; 2nd was to cut the symbols, one at a time, and move them to a fresh ss...when all of the symbols had been moved to the new ss, i then deleted the new sheet...and voila' my original sheet no longer had the symbols or the issue...thx again for your input on the issue...

Ray R

@rer555 

 

I was very pleased that my cell found and initiated you were able to solve the problem yourself.

If the problem is solved for you, would you please click this as the correct answer and if possible a like (click thumbs up).
Thus, the following can see that the problem no longer exists and may also use it as an approach to a solution.
 
Thank you in advance for your understanding
 
I wish you a pleasant day
 

Nikolino

I know I don't know anything (Socrates)