A cautionary tale regarding Excel spreadsheet sharing
Recently, I encountered a reason to be wary about create shared Excel spreadsheets when one ballooned in size. It ended up growing to around 130 megabytes before I tried turning off sharing to see what happened and the size shrunk [...]
One reason why you cannot merge cells in Excel
One handy thing that I didn’t realise that you could do with Excel until the last few months was the ability to share an open workbook between users and collate any changes that are made (it seems that a form [...]
Reading data into SAS using the EXCEL and PCFILES library engines
Recently, I had the opportunity to have a look at the Excel library engine again because I need to read Excel data into SAS. You need SAS Access for PC Files licensed for it to but it does simplify the process of [...]
SYLK: File format is not valid
You can see the above message on attempting to open a CSV file in Microsft Excel. The cause is having “ID” as the very first characters in the file (case is important) because that causes a file type misidentification and CSV [...]