grayed out

My main issue is that cells are not being refreshed after a macro is run (updating source data). A REF error is generated when Cells are being refreshed post-macro. One of the resolution leads is a correction via Data Properties and the External Data Ranges. Though the Properties tab is...

I received a file from a coworker with the insert controls icon on the ribbon grayed out. How do I reactivate it? I can see the insert controls icon in my other excel files. The file was originally an xlsx file for which I did a save as .xlsm. I am able to create and edit macros. I just cannot...

I maintain several databases of client inquiries in an Excel spreadsheet. The spreadsheets include links to pdf files of the actual inquiries and the responses. The linked files are located on the same drive as the worksheets. I have just completed a massive relinking project, as we were...

Hi there, I'm trying to clean some data I received from another department, and they were unfortunately big believers in using merged cells. In order to find and fix them, I typically used Find =>Options=>Format=>Alignment, and from there check the merge cells box to find them. However, on...

Hi Everyone,Can anyone explain to me why the option for rotating around the Z axis is grayed out in the 3-D Rotation section of the "Format Chart Area"? And is it possible to rotate a 3-D pie chart around the Z axis? Screenshot attached.I searched your forum for "z-axis grayed out." Found...