computers

After troubleshooting why my Excel 2007 seemed to be unnaturally sluggish, especially with copy/paste functions, I traced the problem to Microsoft's "Mouse Without Borders" app (which lets you share a single mouse/keyboard with two different computers, and glide from one desktop onto the other...

In a sheet with about 6000 rows, I can scroll without any problem with the mouse wheel, as well as with Scroll Up and Scroll Down If I try to Scroll Here (clicking at about the middle of the bar to the right of the screen): - in Excel 2010, I go to the area around row 3300 :) - in Excel 2016...

We have a N/w of 3 computers. The Access prog is on one computer and is accessed by the other 2 computers. The Appl. runs well on the comp. on which it is installed. But it is slow on the computer accessing it. What can be done for this?

I've been making up a workbook for material summaries at work, and I'm finding a problem on 2 of 4 computers running it so far. Here's what happens: There's some command buttons shown in the picture. the mouse is hovered over the 'refresh summary' button (circled in black). (the cursor isn't...

Hello and thanks for considering an issue I'm bringing up. First off - this is relevant only to files stored on DropBox or, very likely, other cloud storage platforms. And only due to the files being accessed on different computers. The problem appears to be that Excel typically uses absolute...

Hey everyone! New here! I'm working on a student mental health dashboard project in excel and have a high-level question about adding new 'students' that the school wants to help. Schools can have up to 1000 students, so I don't know if it's reasonable to write VBA code to create a new sheet...

Hi, i am having hard time to understand active cell offset Why does the below code offset to different row on different computers If Not Intersect(Target, Range("C1:C1000")) Is Nothing Then Application.EnableEvents = False Cells(ActiveCell.Row - 0, 11) = Now if My active cell is E3 above...

I have automated the creation of a PPT slide. However, the issue I run into arises when I run it on other computers. The size and positioning of the shapes seems to change ever so slightly, but noticeably. I have the shapes set to position themselves automatically based on original position...

Hi everyone, I have this Workbook with several UserForms. The Workbooks is shared between 2 or 3 Computers simultaneously. It is shared using the old way not the cloud. One of the UserForms will work just like a Pop-up message in one especific computer. But, since it is just one workbook, I...

Hi Is there a way to close a specific file that may be opened by one or more users on different computers?

I have several thousand files I want to work on. Each file takes a few minutes of processing so to speed up the process I'm trying to use several computers that all dump their processed files to a central location. What I've noticed is that the different computers end up trying to open files for...

Hey guys, I'm new to this sub. I tried to look for related posts first but to no avail. I created a userform with tons of (working) controls, uploaded to cloud and downloaded it on other computers. The file's main usage will be on the userform. The issue is, on most computers, the userform...

Hello all, I created a macro that creates a pivot table based on a dynamic range, in order to generate a report. When I run it in my computer, everything goes ok, however, when I run it in someother computers, the follow error message appears: Run-time error '5': Invalid procedure call or...

Hi everyone, I'm running a shared workbook on multiple computers, but it does not run on some Computers. On some computers the message "Compile error in hidden Module: This workbook" appears. And in the worst case, the program stops at simple functions like Today_Date = Date (). The computer...

Hello, I've used Excel 2016 for about a year now and just this morning noticed that the visual appearance of my High-Low-Close stock charts has changed on every one of my five computers under the account, in every spreadsheet I have. Specifically, the marker that indicates the closing price is...

I have a worksheet that is connected to many SQL2008 databases, it pull information from DB's to the excel worksheet, I do (Refresh All) every day, After I press RefreshAll , the worksheet ask for password. So far this works fine on 4 computers who have full access to the worksheet, on 2 other...

HI, I have a dataset that looks as follows: Computer Name | Number of Cores | Group Computer 1 | 2 | Group 1 Computer 2 | 4 | Group 2 Computer 3 | 6 | Group 3 Computer 1 | 2...

Hello this is a general question, not looking for code. If I have two computers in different location and not on a network, with the same application, both computers are able to edit data. what I like to do on a regular interval send data via email and each computer would have the others...

Hi All, I have a bit of a head scratcher. I distributed an Excel file for use in the field, with the worksheets locked to protect the formulas. This file is being used by probably dozens of people without problem - except for two persons. One has the German OS on his computer, the other the...

Hi all, i'm having a problem trying to use my existing macro coding to work across multiple computers accessing the same files hosted on Dropbox. Currently I have created macros that will generate consecutive invoice numbers and then export the file as a PDF to a destination file with a prefix...