Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 06-04-2009
Member
 
Join Date: May 2008
Posts: 548
Need help in Excel linking

I want help on something I am trying to do in vain:

I have a fairly large (60C x 2500R). I would like to create external files according to a columns. That is say I want to have a workbook for each month of the year. I have to have connections in both directions, meaning that on some columns, the table base is transmitted to other tables and other columns on other tables feed the main draw.

I know roughly how fixed but the problem is that this picture will evolve with new data and thus new data rows by month to be distributed in folders respectively.
Reply With Quote
  #2  
Old 06-04-2009
Member
 
Join Date: May 2008
Posts: 685
Re: Need help in Excel linking

I think it'll have to go through the program. VBA is not very complicated and can be bcp of chose.

A specific example: the file or at least a screenshot to better understand the demand.
Reply With Quote
  #3  
Old 06-04-2009
XSI XSI is offline
Member
 
Join Date: May 2008
Posts: 271
Re: Need help in Excel linking

Hello,
After some testing with external cabinets a few years ago, I soon came to the conclusion that it was better to use leaves, because the time to update/calculation using external folders quickly become prohibitive, even to do something to extract the necessary data for a particular broadcast.

So if you still want to do filing, make tests to verify performance before investing too much time working.
Reply With Quote
  #4  
Old 06-04-2009
Member
 
Join Date: May 2008
Posts: 548
Re: Need help in Excel linking

@ fellah

This is data that I can not put on the net.

@ XSI

Yes the idea of that was just to have different folders and not have (potentially) 18 people who are working this together.

Should I turn to VBA but I know very little ...
Reply With Quote
  #5  
Old 06-04-2009
Member
 
Join Date: Feb 2008
Posts: 194
Re: Need help in Excel linking

The I think you reached the limits of Excel, transfer info bi-directional, 18 potential users at the same time it ...

Not surprisingly, but an example may be based on real data with cans ...

If you want my opinion, and if you master a slightly Excel, you turn instead to Access.

Entering data like Excel if you spend directly from the tables
Accessible network
Centralization of information
Etc.

If you need help with Access, no problem. In addition to the data dictionary from Excel to Access is easily transportable.

Best regards
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need help in Excel linking"
Thread Thread Starter Forum Replies Last Post
Linking PSN to Uplay Gowd Video Games 6 15-09-2011 10:45 AM
MS excel 2010 unable to insert object when linking to a file on a shared volume Khalida Windows Software 6 14-05-2011 11:06 PM
PHP linking Linux-Us Software Development 3 05-12-2009 02:03 PM
Linking in Acrobat Akuma Windows Software 3 10-01-2009 10:06 PM
Linking MS Project to MS Excel - ODBC Connection manishdk Microsoft Project 3 19-12-2008 07:17 AM


All times are GMT +5.5. The time now is 01:58 AM.