 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Workbook automatically unhiding rows upon opening
We have a shared workbook that our admin staff updates, and our sales staff accesses when on the road. Recently, some of the admin's computers, and all of the sales staff's laptops have begun unhiding all of the rows in this workbook when they open it. For others, the hidden rows stay hidden. I've been tasked with making sure the rows stay hidden upon opening, but I cannot figure out why this is happening. Help? It could be the two groups are actually accessing two different similarly named files.....could be same name in two different directories....problem is common in companies which employ several different Operating Systems.....you could go ahead and force the issue on your copy with a Before-Save macro, but it would only affect YOUR copy, and if the problem is as I have suggested, the results probably won't change......Your MIS folks should take a look at the problem and make sure everyone is opening the same file. Vaya con Dios, Chuck, CABGx3 > We have a shared workbook that our admin staff updates, and our sales staff > accesses when on the road. [quoted text clipped - 7 lines] > > Help? Unfortunately, all parties are accessing the exact same files. > It could be the two groups are actually accessing two different similarly > named files.....could be same name in two different directories....problem is [quoted text clipped - 18 lines] > > > > Help? I know they THINK they are, but have you checked it out to be sure they actually are.....some folks use desktop icons that don't update to new versions of the file....etc. Vaya con Dios, Chuck, CABGx3 > Unfortunately, all parties are accessing the exact same files. > [quoted text clipped - 20 lines] > > > > > > Help? You didn't say what version of XL you are using. In 2003, go to Tools>Share Workbook and click on the 'Advanced' tab. Uncheck the "Filter settings" box at the bottom and see if that helps. HTH, JP > We have a shared workbook that our admin staff updates, and our sales staff > accesses when on the road. [quoted text clipped - 7 lines] > > Help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.