corruption

I have recommenced on a path to learn about VBA and remembered how exciting it is coding and when everything is going great but also how frustrating when they don't :). I recent begun a project were I would take some raw data in a XLSX format (1000's of lines) and do a number of computations on...

I've made a workbook in Excel (obviously) on my Mac, saved as a xls document and emailed it as an attachment. When it is opened on a windows pc (Excel 2007) it isn't displaying or functioning correctly even with macros enabled. For example I have in cell drop-down menus which aren't...

Hi guys thanks for taking the time to look, an odd one here: so i have a template folder with a bunch of excels.used many times before. this time, whenever i write in links to one excel, save and close, upon reopening it is corrupted, wont open without reapiring, and when it repairs the links...

I've been trying to convert several excel tables to .csv format for use in a GIS program. Each time I do this, certain cells in essential column (which is used to join the .csv table to spatial data) get corrupted. The column contains UIDs that are numerical. The corruption places either a ? or...

I'm having strange issues with a workbook and I'm wondering if the issues could be caused by some sort of corruption. The reason I'm asking the question is because everywhere I look online it says corrupt files can't be opened, and these open and run just fine, they just do something strange...

Hi guys, I have the strangest behavior in an Excel worksheet I have ever seen. I have uploaded a small portion of my worksheet to my dropbox. https://www.dropbox.com/s/ptm4ie27k3gl0pc/Strange.xlsx?dl=0 Strange behavior 1 The first formula calculates the age from a date of birth. Works fine, no...