How can I refresh a document I have open in Excel in read-only mode?

Posted by RoboShop on Super User See other posts from Super User or by RoboShop
Published on 2011-11-04T00:45:40Z Indexed on 2013/10/22 3:58 UTC
Read the original article Hit count: 283

Filed under:

microsoft-excel-2007

|

read-only

|

refresh

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it.

Every so often, in order to get the latest changes, I have to close down the file and reload it again. Are there any options within Excel 2007 which allow me to simply refresh a document I have open in read-only mode to the latest version on the server?

Better still, is there a way where this could be done dynamically, without me having to hit refresh?

© Super User or respective owner

Related posts about microsoft-excel-2007

Microsoft Excel 2007 constantly calculating sheets

as seen on Super User - Search for 'Super User'
I believe this happening for two weeks now: Excel 2007 (on Windows XP) is acting funny on my computer; any medium sized sheet with some formulas in it takes a significant amount of time recalculating. I can see this because the "calculating: 2 processors xx%" message was almost unseen before and… >>> More
To pull data into Microsoft Excel 2007 with web queries

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can i perform to enter username and password when want to pull data into Microsoft Excel with web queries??? Have any solution can be used to solve this kind of problem? >>> More
I want to move columns in a gradebook based on the column header title to another gradebook

as seen on Super User - Search for 'Super User'
I have to average grades based on each objective for a new report card we have to complete this year. For example Column one has students names, each additional column will have the objective associated with the assignment. I would like to move the entire column to another sheet for each objective… >>> More
Returning row values based on conditional formatting variables

as seen on Super User - Search for 'Super User'
I'm not entirely sure how to properly explain this, but here we go... I'm trying to create a single budgeting document that allows me to manage purchasing and reconciliation for multiple projects. I would like to create separate sheets per project and have purchased items populate on a master sheet… >>> More
Can I use excel to read barcodes and take me to a specific cell?

as seen on Super User - Search for 'Super User'
I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. My hope is to be able to scan the barcode have it take me to a specific cell in the spread sheet so… >>> More

Related posts about read-only

Shortcut to make something readonly/not readonly

as seen on Super User - Search for 'Super User'
Is there a windows shortcut or non-mouse oriented command to make a toggle a given file's read only status? >>> More
Android - Attempt to write in a readonly database when I open it readonly

as seen on Stack Overflow - Search for 'Stack Overflow'
i don't understand this at all. I try to open a db located in my SD card this way: db = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.NO_LOCALIZED_COLLATORS | SQLiteDatabase.OPEN_READONLY); But in that very line it throws this exception: android.database.sqlite.SQLiteException:… >>> More
Unable to transfer data to or from mounted hard drive

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
So usually i'm good at sorting out issues. But this one has me at a loss! This issues has occured since upgrading my ubuntu so this was workingg prior. I use mounted hard drives to manage my downloads which are then copied over accordingly by a python based app. I found it was having issues with… >>> More
At most how many customized P3 attributes could be added into Agile?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
I have one customer/Oracle Partner Consultant asking me such question: how many customized attributes can be allowed to add to Agile's subclass Page Three? I never did research against this because Agile User Guide never says this and theoretically Agile supports unlimited amount of customized attributes… >>> More
How to convert binary read/write to non-binary read/write in C++

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some C++ code from somewhere that reads and writes data in binary format. I want to see what it's reading and writing in the file, so I want to convert it's binary read and write to non-binary read and write. Also, when I convert the binary write to non-binary write, I want it to still be… >>> More