Timeline for I need to make a master Excel workbook that references other workbooks so I can search for items in one place instead of multiple Excel sheets.
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 23, 2015 at 3:00 | answer | added | Mike Honey | timeline score: 1 | |
| Mar 20, 2015 at 2:23 | history | migrated | from stackoverflow.com (revisions) | ||
| Mar 19, 2015 at 20:48 | answer | added | Steven Martin | timeline score: 0 | |
| Mar 19, 2015 at 20:42 | comment | added | Kyle Hinkebein | Ok, I appreciate it man. It sounds like vb may just have to be the solution.. I'm just going to have to start from scratch with simply vb functions to figure it out then.. I was trying to get this done soon as a surprise for the boss before someone else figured it out.. lol Not a lot of time to work on it at work.. Thanks again for the SSIS warning, I was going nuts trying to figure out how to attempt it, I guess I'll spare myself that madness.. | |
| Mar 19, 2015 at 20:19 | comment | added | billinkc | SSIS is a technology for moving data but it's very inflexible when it comes to data types. Excel interprets the data every time a spreadsheet opens and can just as easily decide a column is text as it is numeric. That makes these two mortal enemies. The fact that you're bumping up against some 255 column import limit in Excel leads me to believe that this will be hydra slaying event. | |
| Mar 19, 2015 at 20:19 | comment | added | Kyle Hinkebein | The information and data base would have to stay local within the company on our servers.. Creating an SSIS or using SQL seems to be all my research leads to, I was hoping there was a simpler option or perhaps someone could explain how to get started. I keep hearing about Excel Connections Manager or Sources Manager but can not find it or figure out how to find/download it.. | |
| Mar 19, 2015 at 19:59 | comment | added | Kyle Hinkebein | I have Absolutely done that and I am not asking this question without having tried everything I can think of. I was concerned about receiving negative points by asking this but I do truly need help. I started using the Connections options in the DATA tab creating links to the workbooks I need referenced in the master workbook but this process is limited to only filling 255 columns of data.. I even attempted a VB script but was utterly confused by it then moved on to other possibilities such as SQL but can't figure out how to download to even try to figure it out on my own. | |
| Mar 19, 2015 at 19:28 | answer | added | Nate May | timeline score: 0 | |
| Mar 19, 2015 at 18:57 | history | asked | Kyle Hinkebein | CC BY-SA 3.0 |