robertsuggs
New Member
- Joined
- Mar 26, 2013
- Messages
- 1
Excel 2007 -- Windows 7
I've developed a pretty slick workbook that uses an ODBC connection to connect Excel with my mysql db. In sheet 2, it essentially dumps the data (personal information type data) from the db into a table. Sheet 1 takes that data and in each row lists a few pieces of data (name, arrival, departure) and then creates a horizontal "bar graph" so the user can see when a person is coming and going (done by conditional formatting).
Each row in sheet 1 is simply linked to a row in sheet 2. I've filled down to row 300 to account for adding more people to the database. Everything works really great, but sometimes WITHOUT SAVING THE WORKBOOK, a few formulas that link to row 129 through (1-last row with data) just magically disappear. Again, the document has not been saved (as verified by the date modified in the OS for the file).
Any ideas?
I've developed a pretty slick workbook that uses an ODBC connection to connect Excel with my mysql db. In sheet 2, it essentially dumps the data (personal information type data) from the db into a table. Sheet 1 takes that data and in each row lists a few pieces of data (name, arrival, departure) and then creates a horizontal "bar graph" so the user can see when a person is coming and going (done by conditional formatting).
Each row in sheet 1 is simply linked to a row in sheet 2. I've filled down to row 300 to account for adding more people to the database. Everything works really great, but sometimes WITHOUT SAVING THE WORKBOOK, a few formulas that link to row 129 through (1-last row with data) just magically disappear. Again, the document has not been saved (as verified by the date modified in the OS for the file).
Any ideas?
Last edited: