Hi - I am continuously experiencing the same issue whenever I export a sas dataset into excel. The newly created excel file does not allow for any filtering, or other data functions. All functions are grayed out. A filename suffix is always appearing that states '[Group]'. I use SAS9.4, Windows 7, and MS Office 2007. Has anyone experienced this before? The only resolution I have found is to close everything and reboot my computer. Then, when I reopen the excel file, all functions are active again. I am using proc export to dbms=xlsx.
Thank you!
Thank you!