Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

The hyperlinks won't work if the path is very long due to limitations in Excel. Paths can be shortened to DOS format using the FSO.ShortPath property in VBA. (see /resources/vba) If you need to print ...