Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drowned in the ocean of Excel Spreadsheets
The extensive use of Excel which is now very powerful has made some people
almost drowned in it. Very large worksheets being established and linked to each other. When I tried to take over spreadsheets of my fellow employee during his being hospitalized, I almost give up. Figures and formulas scattered all across the pages and it is difficult to know where to start from. I'm thinking about pooling Data input totally in one sheet, pooling all the calculations in another sheet and displaying all the reports in other sheet. Does any body have the experience on such arrangement? Thanks SUNAN |
#2
|
|||
|
|||
Hi Sunantoro,
I'm thinking about pooling Data input totally in one sheet, pooling all the calculations in another sheet and displaying all the reports in other sheet. Does any body have the experience on such arrangement? Sounds like the way to go. It is an arrangement I favour. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
#3
|
|||
|
|||
You might even think of separating the data and the logic into separate
workbooks. -- HTH RP (remove nothere from the email address if mailing direct) "Jan Karel Pieterse" wrote in message ... Hi Sunantoro, I'm thinking about pooling Data input totally in one sheet, pooling all the calculations in another sheet and displaying all the reports in other sheet. Does any body have the experience on such arrangement? Sounds like the way to go. It is an arrangement I favour. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
Can Excel Check two spreadsheets against one another for changes? | Excel Discussion (Misc queries) | |||
Is there a virus out there that is affecting excel spreadsheets | Charts and Charting in Excel | |||
Viewing Excel spreadsheets | Excel Discussion (Misc queries) |