Question about Microsoft Excel for PC

2 Answers

On a shared workbook, I have hidden columns and workbooks that do not remain hidden when opened by other users

Posted by on

  • Conrad Roseman Apr 04, 2011



    Hello,



    I have administrator rights, I can add and edit the workbooks. However when I hide the columns or workbooks, the changes are not updated when the users open the file, can you help?





    Best regards,

    Conrad

×

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 977 Answers

Hello!

Try protecting (locking) those columns that you're trying to hide...
Follow the instructions here (you can switch to a different version's instructions at the top).

In case of a problem or clarification or my solution was insufficient, don't hesitate to post me a reply before rejecting my answer.
If you are satisfied, rate my solution with the "thumbs" or (even better) add a testimonial.

Good luck & best regards,
Pelu.

Posted on Apr 04, 2011

  • Ran Kedar
    Ran Kedar Apr 04, 2011

    Another thing you could try is putting a macro, that will run each time the workbook is being opened, and will hide the columns you'd want to hide.
    For example:

    Option Explicit

    Private Sub Workbook_Open()

    Columns("B:D").Hidden = True

    End Sub
    Will hide columns B through D...

    Make sure you have macros enabled!

    Regards,
    Pelu.

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Guru:

    An expert who has written 7 tips or uploaded 3 video tips

  • Master
  • 406 Answers

Hi there fellow Microsoft user. I've encountered the same problem the first time I've worked for a networked environment. For all the changes to appear on the shared user here are the things you have to keep in mind:
1. You should have the administrator righst( The capability of making changes to the document e.g. delete, edit)
2. For the users to see the changes you've made, they need to close the file in question for them to see it. And of course their computers have to be online or sync within the network.
3. If the users have admin rights as well then they can definitely see the hidden columns and workbooks.
Hope this helps! Cheers

Posted on Apr 04, 2011

  • Fix R US Apr 07, 2011

    You have to make sure that the document you've edited were closed already by other users. Because if they're still being viewed they will not see the changes you've made. It will only referesh on their end if they close it and open the file again

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Why does a column disappear in a shared workbook on Excel?


Use Track Changes under the Review ribbon. Good luck if the option to accept or reject changes is still available.

Jul 24, 2014 | Microsoft Office Excel 2007

Tip

How To Save A Workbook In Another File Format? Most of the time, users...


How To Save A Workbook In Another File Format?
Most of the time, users prefer to save the workbook in the current file format as a.xlsx extension. But often, it's the case where you may need to save a workbook in other file formats, such as the file format of an earlier version of Excel, a text file, or a PDF or XPS file. MS Office technical support experts have suggested users that while saving their workbook in another file format, they need to follow few of its formatting, data, and other essentials features which may not be saved well. For a list of various file formats, also known as various file types, one can easily open or save in Excel 2013

Steps to save a workbook in another file format
Step1: Accessing the workbook
·Open and get access to the workbook which you wish to save.
Step2: One DRIVE option
·Under the 'Places' section, simply pick up the place where you wish to save the workbook. For example, if you choose the "OneDrive" to save it to the Web location or in the Computer to save it in a local folder, you can save it as your Documents.
Step3: Save As dialogue box
·In the "Save As' dialog box, one is required to navigate to the location according to their choices.
Step 4: Working with the file formats
·In the Save as type list, just click on the file format which you wish to save and then click the arrows to easily scroll to the file formats that aren't yet visible in the list as suggested by MS Office tech support team members.
A note of caution:
·The file formats that you'll see may vary, depending on what type of sheet you are actively working in your workbook (a worksheet, chart sheet, or other type of sheet).
·In the File name box, try to accept a specific suggested name or simply type a new name for your workbook.

Fix your issues related to MS Office to get your issues resolved at much faster rates. We are accessible for our users at MS Office customer support Toll-Free 1-800-213-8289 department as and when needed

on Apr 28, 2017 | Miscellaneous

Tip

How to protect MS Excel file using password?


In Microsoft Excel, you can protect a single cell, group of cells on a worksheet or an entire workbook by applying password so that unauthorized person can not display as well as modify your document. You can apply two types of password.
Password to open the document:
If it is applied then you have to give the correct password to open the workbook. Otherwise you cannot open the workbook.
Password to modify the document:
If it is applied then you have to give the correct password to modify the workbook. Otherwise your workbook is opened but you cannot modify the workbook. It means that your workbook becomes read-only.
To apply a password to MS Excel document, follow the given steps:
First click on "Tools" menu and select the "Option" from drop down menu.
A windows dialog box will appear, here select the "Security" tab.
Enter first password in "Password to open" text box under "File encryption settings for this workbook" section and second password in "Password to modify" text box (if required) under" File sharing settings for the workbook" section then click "Ok" button of dialog box.
Microsoft Excel will open "Confirm Password" dialog box for the confirmation of passwords. The maximum length of password is 15 characters.
Re-enter the password to open and password to modify and click "Ok" button of Confirm Password dialog boxes one by one.
Now close the file and then reopen to test the password.

on Dec 03, 2009 | Computers & Internet

1 Answer

Excel 2003 cell is highlighted, font color is selected, but the color on the screen remains black. When printing the color prints out correctly while showing black on the screen


to remove all formats....
i.e.
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy

new work book
select cell edit/paste special/values

now do the formating/color/font/size etc in the new workbook and check if they work here

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Same problem - excel files balllooning from 20Kb to 45Mb


This could happen if your workbook is being shared.
1. Make a backup copy of your workbook (Excel file).
2. Open it in Excel
3. Check under Tools > Share Workbook and see if the "Allow changes by more than one user..." option is selected. If so, try unchecking it and save the workbook
4. Check the file size under File > Properties > General tab


Another possibility is that there are a lot of unused cells with "invisible" formatting. To check that you can try pressing Ctrl+End and see where the end of your document is. If it is way beyond your current work area, select those extra columns and rows and go to Edit > Clear > All (Note: This will delete everything on those cells)


Aug 19, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Microsoft Excel files: File size becomes very big while saving.


Whenever Excel closes unexpectedly, "ghost users" can remain in a "shared" workbook. Excel tracks changes in order to synchronize between users, resulting in huge file sizes. In order to fix the problem click Share Workbook (Review tab, Changes group in 2007 or Tools/Share Workbook in earlier). On the Editing tab see if there are any "Users" using the workbook. If so, remove them by clicking "Remove User." When you save again, the file should be back to normal. Being this is a Microsoft product, I want to re-emphasize the word "should" from my previous sentence...

Dec 31, 2008 | Microsoft Office Excel 2003 for PC

2 Answers

Sharing Problem


some colors are not available in office 2003

under (office 2007) excel options (alt-t-o), save tab, you can choose which colors will be seen in previous excel versions.

Sep 23, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Matching data


1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

1 Answer

Excel Macro


Try these links you could find out

http://www.vbaexpress.com/kb/getarticle.php?kb_id=706
http://www.computing.net/programming/wwwboard/forum/5902.html

Sep 23, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

41 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...