I can create a file in SQL that has formulas in it (i.e. '=A1*B1') and I can send them to my PC and open them in Excel. However, the formulas are showing instead of the results. If I click inside the cell and hit Enter, I get the value instead of the formula. BUT, I want this automated and don't want a macro, so I want this to be opened to show the formula result instead of the formula without doing anything. I tried using CAST to a few other types, but that didn't work. It works if I send it as a HTML, but would prefer the xls extension, if possible. Thanks for any thoughts on this.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!