Shared File Does Not Refresh Info?
Jan 17, 2014on one of the computers where shared file is opened, the info is refreshed only if closing/re-open file
View 1 Replies
ADVERTISEMENT
Being Able To Refresh Data- So That When I Hit Refresh It Gets Info Frm Another File
Jul 27, 2006i have an excel spreadsheet with 27 or so workeets. it contains sales figures in it.
I want to be able to link mutiple cells of this workbook to another workbook so that it retreives that data, So that when I hit the refresh (!) button it will automatically put the data in. I will recieve new sales figures (new files) on a monthly basis so i want it to be able to update the figures to the new figures.
Excel Pulling Outlook Calendar Info (Shared)
Dec 26, 2013I have found a code to pull outlook calendar information from outlook to excel. I am trying to determine how to pull from Shared Calendars. This code looks as if they calendar has a number (9), but I can't figure out what the other calendar's numbers would be. How to pull from Shared Calendars and how to pull the month for which the calendar is on. My shared calendars are under Calendars>Shared Calendars in outlook. So for example, I would need to pull John Doe's calendar information for January if the calendar was on January. My code is listed below.
Sub ListAppointments()
Dim olApp As Object
Dim olNS As Object
Dim olFolder As Object
Dim olApt As Object
Dim NextRow As Long
Set olApp = CreateObject("Outlook.Application")
[Code] ......
Shared File
Jan 7, 2007I am designing a workbook that techs in my lab can use from any of our network computers to submit requests for making chemical solutions they need to run their tests. Currently they have to fill out a paper form to make the request, so this should make things a little more efficient and less paper intensive.
I have the workbook designed and working, but now need to implement it as a shared file and this is where the problems are occurring. I assumed that shared files could allow access to the same file AT THE SAME TIME with no issues, but that is not the case in Excel97 on our network. Using two networked computers side by side I have tried updating the shared file at the same time and got a myriad of popups. The include:
1) Do you want to save the changes you made to "..."? (I did not include the actual filename here.)
2) A file named "......" already exists in this location. Do you want to replace it?
3) "......" is now available for editing. Choose Read-Write to open it for editing.
4) This file is locked. Try the command later.
5) This file has been locked by for saving. Try again later.
Question:
Are these error messages normal for shared files? Do some reflect issues more with the network than with Excel? Is there any way to get VBA to simulate clicking a Yes, No, or Cancel, or OK whenever a one of these specific messages comes up?
Save The Shared File
Nov 3, 2008We have Excel 2003 at our workplace. I have shared a file, which is used by many users, so we can use the file at the same time. My problem is that if let's say I am writing a value in cell C2 and another user uses the same cell and writes another value there, and he saves the file and then I try to save the file as well, Excel will ask me which value to keep (the value written by the other user, or my value). Actually what I would need Excel to do is to save both, and put one under the other.
View 2 Replies View RelatedHow To Add Ticker Ro Shared File
Nov 27, 2008how to add ticker( splash roller message to shared file) like when the user opens any sheet in shared file there should be some rolling msg in the bottom.
View 9 Replies View RelatedShared File Growing Massively
Jun 5, 2007I have been reading up about shared workbooks within here which quite frankly is annoying me! I have rebuilt a spreadsheet from yesterday and shared it with:
Dont Keep change history
Update changes when file is saved
The changes being saved win
At start of day the file is 660kb, now by lunchtime I have it as 15mb. Does anyone know why this occurs? Becuase the file is getting bigger this is affecting performance
Track Changes History In Shared Excel File?
Jun 4, 2014how to delete the track changes history whilst the excel file is shared?
View 3 Replies View RelatedShared File Causing 1004 Error?
Feb 7, 2014why my code would hit a run time error on a shared file? It works fine unshared. This is on a ActivateSheet Worksheet Event, Code is housed in a Module and called when activated.
[Code]......
Excel 2010 :: VBA Editor Pops Up With Shared File
Jul 30, 2014I have an Excel file in Shared Mode...
Now, when it starts, I have a popup form asking for password for access for it. The problem is that for one person - AND ONLY THAT PERSON - the VBA Editor window opens and she has to press the "Play" button for it to hide and be able to enter the password to access the application.
The editor is not showing on any other computer. All computers are running Excel 2010.
Macro Doesn't Work When Workbook/File Is Shared
Aug 30, 2006I am encountering a specific scenerio where In I am creating a New file by copying one of the sheets And renaming that With todays date. here starts me problem when I try To share the sheet To work around I am seeing that th macro Is Not copying the sheet properly even though i have given PasteSpecial. The code goes here
VB: AutoLinked keywords will cause extra spaces before keywords. Extra spacing Is Not transferred when copy/pasting, but Is If the keyword uses "quotes".
Sub Newsheet()
sheetname = Format(Now, "dd-mmm-yyyy")
MsgBox sheetname
sheet_count = Worksheets.Count
'Checking for Replication................
Creating Folders On Shared Drive - Path File Too Long
Dec 5, 2011I've made a macro that would create some folders on a shared drive.
there is an issue if the path i want to create is too long.
I get this error.
Uploaded with ImageShack.us
is there anything we can do to pass this or any solution for it?
Workbook Containing Macro To Reduce File Size Locks Up When Shared
May 28, 2008I've been having trouble recently with my workbook file size growing rapidly due to copy and paste commands and such. I found a very nice macro to reduce file size called ExcelDiet located at [url]
Option Explicit
Sub ExcelDiet()
Dim j As Long
Dim k As Long
Dim LastRow As Long
Dim LastCol As Long
Dim ColFormula As Range
Dim RowFormula As Range
Dim ColValue As Range
Dim RowValue As Range
Dim Shp As Shape
Dim ws As Worksheet
Application. ScreenUpdating = False
Application.DisplayAlerts = False
On Error Resume Next
This code works fine until I share the workbook. Can anyone take a look at this code and provide some information as to why this might be happening?
Shared File Prints Differently For Different Users - Autofit Wrapped Cells
Apr 16, 2014Here's the details:
Same file shared by many users in the office. File is maybe 2200 rows long and 20 columns wide. Last column is a text field where users can explain variances. Cells in the last column are wrapped and the rows auto-fit on the height. Zoom is set at 100%.
One person opens the file and it looks fine on the screen. Print preview also looks fine. File prints out perfectly.
Another user opens the file and it looks fine on the screen. BUT, print preview shows that the bottom line or lines of text is cut off. File prints exactly like the preview showed with clipped text.
Both users can point the file to the same printer, but that doesn't seem to change anything. Still prints with text clipped for one person and perfectly for another...
Refresh XML Data In A Map If The Source File Is Updated
Apr 7, 2009If I have a spreadsheet with some data loaded in through XML and viewed as a
map, what is the VBA command to reload/reimport the source XML data?
The scenario is that the source data (XML) may change at any time, and I would like to reflect this to the presentation layer (excel) at regular intervals. I have a loop set up but cannot find the command to reset the source XML data.
Enable Auto Refresh Of Web Queries When File Opened
Sep 22, 2006I have a special use PC which will power a projector 24/7. When it reboots I want it to load Excel, open a spreadsheet, and then connect to the web to get data using web queries.
My problem is that I get a dialogue box each time the spreadsheet is opened: "Enable Automatic Refresh." I need to remotely reboot the PC from time-to-time so I can't click the button.
I have set my security levels to low and that does not help.
Pivot Refresh After ODBC Query Complete Refresh
Jan 4, 2008I have a query with ODBC connection to a SQL database. This query's parameter is linked to a cell. The resultant data is the source for a pivot table. I want to refresh the pivot table, when the query is run. I've tried using the cell that triggers the query....but the problem is that the query takes about 10 seconds to run. By the time the query returns new data....the pivot has already refreshed. I need it to refresh AFTER the query is complete.
I tried adding a cell that sums up the data from the query...thinking when THAT changes (due to updated data), to trigger the pivot refresh. Problem is that I don't know the trigger for when the sum cell changes (ie....formula change, not typed in.)
Fill Info In Sheet One And Have Same Info Appear In All Sheets That Follow
May 12, 2014I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
View 3 Replies View RelatedHow To Fill Vertical Columns With Info From Horizontal Info
Aug 22, 2014I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
When Query Refresh Its Say "Enable Automatic Refresh"
Jan 13, 2009I've got a spreadsheet with a few queries to extract data into my sheet. Whenever I open the spreadsheet, I get a "query refresh" dialog box, asking if I want to "Enable automatic refresh". I keep clicking on the "Enable" button but I have to keep answering the question for each open. Isn't there a way to set "yean - ok - refresh the data" so that I don't have to keep saying "yes"?
View 2 Replies View RelatedRefresh Pivot Table VS Refresh Pivot Cache
Nov 27, 2007Will someone please tell me the difference (if there is a difference) between the following 2 lines of ....
View 6 Replies View RelatedChanges To Shared Workbook
May 6, 2006I have an Excel workbook which is networked throughout our business. Its been in daily use for years with no problems. Every month I add a new sheet and to do that I untick the "allow changes by more than one user...etc". However this month the tick is greyed out and wont let me clear it. The pc's run windows XP professional with Excel 2003.
View 2 Replies View RelatedShared Spreadsheets
May 20, 2006I have a spreadsheet which needs to be shared by 10 people. The spreadsheet is fairly simple but I don't know the best way to do this. I have heard of public folders or to share the .xls.
View 4 Replies View RelatedVba On Shared Spreadsheet
May 31, 2007I have a 4 MB Excel file containing some very basic VBA that is shared on a server (it is a large file because it contains LOTS of "VLOOKUP" functions). But the VBA only works a part of the time. I assume the reason it might not work is because the server at that time was under high traffic and thus the VBA failures can be traced to poor server performance at that time.
View 4 Replies View RelatedRemove [Shared] Workbook
Jul 22, 2009I have a workbook that is no longer being shared. I tried clicking on Tools > Shared Workbook. BUT i keep getting a message saying "The file C:CCTPAccountsSummary1.XLS cannot be found". Is there any way to kill this Shared workbook so I am free to modify everything?
View 2 Replies View RelatedCombobox In Shared Workbook
Dec 16, 2008Please follow the link ..... This works perfectly for me.. But it doesnt seem to work in shared workbooks.
View 14 Replies View RelatedSpeed Up Shared Workbook?
Aug 19, 2013how to speed up a shared excel worksheet?
View 4 Replies View RelatedMerging Shared Worksheets
Apr 27, 2008I have a master timesheet that i would like to update for several employees. Each employee will be sending their own spreadsheet at the end of the month. the columns in the spreadsheets have the date, the employee's name, the project they worked on, and how many hours they worked on that project.
when i receive all of the employee's spreadsheets (they will be emailing them to me) then i would like to import the data into a single table that i can then evaluate using pivot tables and pivot charts.
I tried using sharing and merging but i can't figure out how to have their information merge into a single table without overwriting each other (the numbers of rows with information is different for each employee and is not predictable - it will vary from month to month).
I would like to make this as automatic as possible. Ideally, they will send their spreadsheets to me and i would like to have their information automatically imported into one big table.
Macro- Shared Worksheet
Mar 16, 2009I have a shared worksheet my self and a few others key pricing into weekly, more or less a price check for stores we service. I have created another workbook that has the same basic template with links to the "shared" worksheet. In this workbook Im trying to run a macro to copy the pricing "template" into a new tab in the workbook. I keep getting this error as it pertains to "sheet". I would like the tab that is created to be named whatever the current day is if possible.
Sub StoreWeeklyData()
'
' StoreWeeklyData Macro
' Macro recorded 3/16/2009 by : Creates a tab for current week pricing data.
'
' Keyboard Shortcut: Ctrl+s
'
Sheets("Template-Link").Select
Range("A1:AM61").Select
Selection.Copy
Sheets("Template-Link").Select
Sheets.Add
Sheets("sheet").Select
Shared Workbook Saving
Mar 5, 2010How do I get a shared workbook to automatically save upon every change by each user. The only way I can get this to work (at this point) is to run a macro that updates every 45 seconds IN EACH WORKBOOK! It's counterintuitive because the workbook is shared (on a network), but each user must start the "time" macro in their "individual" SHARED workbook to allow the automatic saving.
What am I missing? There has to be a more efficient way to do this, right?
Code below
HTML Sub Time()
Call Save
Application.OnTime Now + TimeValue("00:00:45"), "Time"
End Sub
HTML Sub Save()
ActiveWorkbook.Save
End Sub