Any idea?

[pruleone]

Hi,

I made excel workbook, with lots of sheets. Some of them are hided, some not.
Those which I have hide, in those are lots of formulas. Those which are opened, into them other people need to insert data, there are also some formulas.

My idea was to put so called master fail into place where evrybody can acess. Then people will download it, insert needed data and save the fail in their hard drive. Data needs to be save because to insert all needed data would take about hour or even more. So it isn't very smart to insert every time needed data.

It is all nice, but there will be problem when I will change anything in master fail. So thoses changes would not appear in those workbooks which are already saved.

Maybe someone can make any suggestion, give me any idea what to do, that if I would change master fail, then this change would appear to everybody?

Maybe I should make some kind of VBA based button, so people would not save fail, but they save only inserted data, so next time they will press samekind of button and all data will automaticly appear into workbook.
Maybe there are other ways?

 

[MakeItSo]

Handling data that needs to be processed, possibly analysed and singular excel sheets do not go together well.
I would recommend switching to a backend/frontend solution using access.

The people would then have some sort of compilation of Access database on their computers, whose tables would be linked from the central database.

Would that solve your problem?

Cheers,
MiS

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell

 

[genomon]

MakeItSo is correct. Excel is great at handling flat files, but you need a relational database, and Access has some great forms and reporting tools.

Ever notice how fast Windows runs? Me neither.

 

[pruleone]

Thank you,

I will think about it and maybe access is best solution.

 

[GSCaupling]

Hi pruleone,

Welcome to Tek-Tips!

This is off-topic, but I would recommend using thread titles that are more descriptive than "Any Idea?". That title doesn't tell others anything about the problem or even what application you are using. Some members may skip over it, which obviously hurts your chances of getting the needed solution.

I should note that the titles on your other five threads were fine.

Just a thought. Best of luck with all your computer issues!

GS

[red]******^*******
[small]I[/small] [small]Love[/small] [♥] [small]Redundancy.[/small][/red]

 

[pruleone]

When I wrote that thread, I just didn't get any idea what to put to the title
I know that good title is basically half of question and also answer.

But thank you.