Over 1 million tech questions and answers.

Works: View Excel file?

Q: Works: View Excel file?

Need help inporting xl document into microsoft works spread sheet or source for ex viewer

Jim Leonard

RELEVANCY SCORE 200
Preferred Solution: Works: View Excel file?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Works: View Excel file?

Excel viewer:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q273711

Or email to [email protected] and I'll convert it to Works for you.

(I broke your question off of another question.)

Read other 1 answers
RELEVANCY SCORE 60.4

How can I view a PDF file and an Excel file on the screen at the same same time? Every time I open a PDF file, everything shuts down, excel for the PDF. Whenever I click off the PFD, I see everything else, but the PDF is gone. I'm trying to get some info from the PDF to Excel, but it's really hard to do this in Widows 8. In Windows 7 and previous versions, I could see more than one thing on my screen at the same time. Now, the PDF simply takes over control of everything else, so you see the PDF and that's it and that's all.

Thanks everyone.

A:How to view a PDF file and an Excel file on the screen?

Oh, never-mind. It was some weird Adobe thing that took over control of my computer. I uninstalled that other freaky thing, and now I have the real PDF reader back.

Read other 1 answers
RELEVANCY SCORE 59.6

Hi
I am using Exel 2010 - when I save my workbook on the server for the rest of the team to look at, my changes do not show up in their version. However, when I pull up the workbook on my system - all my changes are there. Also, I cannot see their changes eventhough we are all using the "same" workbook name.....

Help please.

A:Cannot Save Excel file for others to view on Network

What if you put your file on SkyDrive for all to share, or change permissions as you see fit?

Read other 2 answers
RELEVANCY SCORE 58.8

My Excel file closes by itself when trying to view macros.

Tech Support Guy System Info Utility version 1.0.0.9
OS Version: Microsoft Windows 10 Enterprise, 64 bit, Build 18363, Installed 20191127182037.000000-240
Processor: Intel(R) Core(TM) i5-8365U CPU @ 1.60GHz, Intel64 Family 6 Model 142 Stepping 12, CPU Count: 8
Total Physical RAM: 16 GB
Graphics Card: VNC Mirror Driver
Hard Drives: C: 237 GB (171 GB Free); D: 931 GB (789 GB Free);
Motherboard: Dell Inc. 0PD9KD, ver A00, s/n /B67Q2R2/TW3207098N0177/
System: Dell Inc., ver DELL - 1072009, s/n B67Q2R2
Antivirus: McAfee VirusScan Enterprise, Enabled and Updated
 

Read other answers
RELEVANCY SCORE 51.6

Lenovo T500 Intel Core2 Duo T9600 2.8GHz
Win 7 Professional SP1 64 bit
MS Office Professional 2010 v14.0.7106.5003 32-bit

I've had a persistent problem for several months since I migrated to a new hard drive. Outlook 2010 calendar is working, but only in Active List view. Any attempt to change to Preview or Calendar view produces the error message, "Could not read the calendar." Changing from Active List to List works some of the time, but inconsistently and sometimes it will hunt for the list and offer the same "Could not read the calendar." error message. This is very frustrating as I find it difficult to manage the list view and am accustomed to seeing the calendar week view.

I use an Android phone and use gmail and Google calendar to see mail and appointments on my phone. So, I've got Google Calendar Sync 0.9.4.1 running. Google Calendar Sync appears to be operating normally. I have a nice calendar view on my phone or web-based from my computer. I have tried adding the Google calendar to Outlook but it is a duplicate of the default calendar and I can't set it as the default. Also, MS Office does not permit me to delete the default calendar.

I don't like any of the work arounds. I just want the calendar to work like it should. Research discloses no real hint of anything that works including running scanpst. Scanpst does a great job at fixing the problem by wiping the whole calendar thanks very much MS.

If you have any clue as to the cause and bette... Read more

A:Outlook 2010 Calendar, only active list view works, calendar view err

Try Microsoft's CalCheck tool. "The Calendar Checking Tool for Outlook (CalCheck) is a program that checks the Microsoft Outlook Calendar and items for problems or for potential problems."

You can download it from here:
Download Calendar Checking Tool for Outlook from Official Microsoft Download Center

Read other 3 answers
RELEVANCY SCORE 50

Hi, i wonder why my Icon does not show in Large Icon view and can be seen in other Icon View? It is invisible when you use Large Icon view. And i can't change my desktop back ground at all. It just won't save the change. Any help is appreciated.

A:Window unable to view file in Large Icon view

Hi there,

You might want to consider a System Restore if this is a recent occurrence.

Using the System File Checker (sfc scannow) would be my next suggestion.

Read other 4 answers
RELEVANCY SCORE 48.4

Hi there,

I am trying to use SQL.REQUEST to pull data from one excel file (a master data file) to another one, and I can't get it to work. I think I don't have the correct connection string specified.

I'm using Excel 2002 on Windows 2000.

The task is, I need to build dynamic queries based on other cells in the "output" spreadsheet, such as, get a count of all records in the master file where the date field is equal to [cell reference] and the ID field is equal to [another cell reference] and a third field is equal to [third cell reference]...
So that, if the values in those referenced cells change, the records that match (and get counted up) will be different.
Also, there will be at least 10 different queries (I do a sum on a field that is a time duration, an average on that same field in another, etc) in different places on the spreadsheet.

I was able to get a simple query to work in Microsoft Query if I used static values, ie, I typed them directly into the criteria... however, these need to by dynamic so that when the same spreadsheet (a report template) is "saved-as" and new values for the criteria are input, the queries don't have to be re-created.

So, using MS Query, I can connect to the master data file and get the correct result... but I believe what I really need to use is SQL.REQUEST, so I downloaded the ODBC add-in and installed that.
I just can't seem to figure out what my connection string argument needs to be.
Th... Read more

A:Solved: sql request in excel file, to another excel file - connection string?

Nevermind folks - I googled +excel +"connection string" for probably the 20th time in 4 days... I usually investigate all result about 7 pages deep before giving up, and this morning, all of a sudden a new result popped up right at the top:
http://www.connectionstrings.com/excel

at about the same time, my boyfriend finally took a look at it, and he came up with this result: http://www.devlist.com/ConnectionStringsPage.aspx

I used the syntax in this example
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
AND IT WORKS!
(I almost got up and danced, I was so happy)

Just thought I'd come back and post the solution, in case anyone else ends up finding this thread in the same position I was in.

Now how do I mark this thing solved?
 

Read other 1 answers
RELEVANCY SCORE 47.6

My issue started over a month ago. Everything was working fine...then suddenly the internet would only load google.com. I guess it wasn't completely "suddenly"....I downloaded chrome (on a whim). That is the only thing I can recall doing. It didn't work after I tried to use it. After days of searching and trying to figure it out, I reinstalled OS (XP Pro). After installing updates, I continued to have this problem. I tether from my android, and also "connect" the usb to get pics and things from phone to computer, and read that viruses can affect certain flash drives so I formatted and scanned my sd just to be sure. I have since reinstalled 3 times in the past month or so. My connection is really slow so updating is a task in itself. I lost 13 years worth of research and data (family pics, videos, etc.). I really don't care about that as such....I'm just frustrated with all this at this point. I installed McAfee about a week ago and it said it found and deleted a virus, but nothing has really changed. Okay, I'm kind of venting here and not being specific about the issue....I apologize. This is some of what's happening:IE 8 only works in compatibility view. When not in this view, only google.com loads. I can load facebook by typing in https://www.facebook.com (as well as other similar sites). When google loads a search, I click and it loads....for-never I can't click on the "login" on some sites (like ... Read more

A:IE only works in compatibility view

Hello,I will be helping you with your problemsSome points for you to keep in mind while I am helping you to make things go easier and faster for both of us Please do NOT run, install or uninstall any programs, unless instructed to do so.
We ask you to run different tools in a specific order to ensure the malware is completely removed from your machine, and running any additional tools may detect false positives, interfere with our tools, or cause unforeseen damage or system instability. Please do not attach logs or use code boxes, just copy and paste the text.
Due to the high volume of logs we receive it helps to receive everything in the same format, and code boxes make the logs very difficult to read. Also, attachments require us to download and open the reports when it is easier to just read the reports in your post. Please read every post completely before doing anything.
Pay special attention to the NOTE: lines, these entries identify an individual issue or important step in the cleanup process. Please provide feedback about your experience as we go.
A short statement describing how the computer is working helps us understand where to go next, for example: I am still getting redirected, the computer is running normally, etc. Please do not describe the computer as "the same", this requires the extra step of looking back at your previous post.NOTE: At the top of your post, click on the Watch Topic Button, select Immediate Notification, and ... Read more

Read other 27 answers
RELEVANCY SCORE 47.2

I absolutely loved the Windows 10 reading view app, but it doesn't seem to work on many sites. Since the last Windows 10 upgrade, it no longer works on sites it worked on previously. Is there anyway to get it back? Please fix this to work on all sites as it is a great feature for those of us who like reading online. Thank you.

A:Reading View App No Longer Works

Originally Posted by dustnik


I absolutely loved the Windows 10 reading view app, but it doesn't seem to work on many sites. Since the last Windows 10 upgrade, it no longer works on sites it worked on previously. Is there anyway to get it back? Please fix this to work on all sites as it is a great feature for those of us who like reading online. Thank you.



This is Reading View in Edge you're talking about? I'm afraid 'we' can't fix it because TenForums is, as it says at the bottom of each page....




...an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation.



We can, perhaps offer advice that may help. For that we'd need to know:
the address of a page that used to work for you but now doesn't.the build number of your Windows 10 (run Winver to find out).

Read other 1 answers
RELEVANCY SCORE 46.8

I;m working on a friends Eee PC Netbook and its connected, AIM works fine but no webpages will work. Any suggestions?

Read other answers
RELEVANCY SCORE 46.8

I have Openfire 3.7 ( XMPP ) along with Jappix Mini chat 0.7. It is working fine on all the browsers except on IE9.
Mini chat get disconnect in default IE9 mode. Jappix chat works on BOSH server as Http Bind. We use ProxyPass / http://127.0.0.1:7070/http-bind/ to connect to Openfire server.
It might be cross-domain issues but not sure. We are using Openfire BOSH.
On IE9 it is showing encountered errors. However when I click on Compatibility view of IE9, it get connected and work fine. Please help or advice.

Please advice what should I do to make changes in my HTML or PHP to have chat connected to XMPP server.

A:IE9 compatibility view works for Mini chat

"when I click on Compatibility view of IE9, it get connected and work fine"

So what's the problem then? Just use compatibility view.

Read other 5 answers
RELEVANCY SCORE 45.6

Hi there
I couldn't find a specfic forum for this question, so sorry but it had to go here!

I am running an 8-channel DVR card for a shop's security and it works fine for the most part. However I'm having troubles with the remote view through IE (via ActiveX controls) It works fine from any XP machine and it seems from Vista Home, but not from a Vista Ultimate machine (and I've tried from both 32 and 64bit versions) - The conection is fine, IE brings up the same interface, but the video images do not appear.

The manufacturer can't (or won't) help me out with this (as from his point of view it works fine as he has a Vista Home machine that can login pefectly) so I was thinking there must be someone who might have an idea of something I need to tweak.

I've tried turning off all the fancy Aero stuff, different graphics modes and resolutions, to no avail. I've tried disabling firewalls also.

Does anyone have any idea where I might start tweaking next? I could understand if I couldn't get it working from a Vista machine full stop, but considering it works from any XP machine, and from a Vista Home machine, there must be something I'm missing!

Any help would be appreciated.

Read other answers
RELEVANCY SCORE 45.2

I have a user with a Surface running Windows 8.1.  When he is on our network, LAN or VPN, he is not able to see a folder view when connecting to an external FTP site.  When off our network, he is able to get a folder view of the files on the
external FTP site.  I am trying to determine what could be preventing the folder view.  The Surface is on our domain.  I tested with my laptop running WIN7 and I get the same results.  I am hoping someone has experienced this issue and
can tell me what could be the root cause.  What networking or Information Security appliance could prevent a folder view on a Surface and laptop.  

Read other answers
RELEVANCY SCORE 45.2

Please help me,
How to copy data from last row used of excel file to new excel file using vbscript?
 

Read other answers
RELEVANCY SCORE 45.2

While in excel, I would like to open another excel file and read some information.

The file I am reading from, will have a row with "Avg." in Col A with data in Col B through L in that row that I want to extract. The data line will be in a different place in all excel files and there may be 2 lines to read.

At this time, I have used the Open command successfully to find the file but do not know how to proceed (?the open structure may be wrong?).

I am familiar with loops and variables but can can not figure out the rest unique to excel.

Any help would be appreciated.
 

A:Solved: Read excel file B while in excel file A

Read other 16 answers
RELEVANCY SCORE 44.8

Hi, does anyone know of a program that will allow me to view excel files without having to install the full version of office/excel?

Thanks

A:To view Excel files

you can download the excel viewer from the office website

Read other 4 answers
RELEVANCY SCORE 44.8

I'm running Office 365 on Windows 8.1. Excel was working fine until today. When I went to open any spreadsheet that is on our network drive and created by other users, the spreadsheet almost looks like a screen shot as if someone inserted a picture. The tabs (Sheet 1, Sheet 2, Sheet 3) are not at the bottom and are embedded into the document itself. I can only see columns A - G and cannot see anything further than that. However, when I go to create a new spreadsheet, everything is fine. It's only when I open other spreadsheets that this anomaly occurs.

Can someone help to figure out what could be causing this problem? As I said, everything was fine until today. The only thing I did differently was enable PowerPivot.
 

Read other answers
RELEVANCY SCORE 44.8

I have a problem viewing files:
I can only see my Excel files in Full Screen mode!!
This problem occurred after installing latest windows updates. Uninstalling has not solved the problem.
Any ideas how to solve.

A:Cannot view Excel files

Run System Restore - choose restore point prior to updates -
START | type rstrui

Check the Reliability Monitor - see if anything else installed -
START | type perfmon /rel

What version Office are you runnning... 2007, 2010..?

Are all Office related Windows Updates installed?

Regards. . .

jcgriff2

`

Read other 3 answers
RELEVANCY SCORE 44.8

Hey BC Community,

I know Excel 2007-2010 have the ability to open .xml files, but does 2002 have the ability to do so?

Thanks,

5h4d0wNews

A:Can you view XML in Excel 2002?

Excel 2002 enables you to open and save files in the Extensible Markup Language (XML) format.Above quote from: http://support.microsoft.com/kb/288215

Read other 1 answers
RELEVANCY SCORE 44.8

I have a small spreadsheet which doesn't fill the screen, but I don't want to save all the white space around it. I've seen Excel sheets before where just the relevant cells were saved and the rest of the page was greyed out, a bit like "no background" in an image file.

Any suggestions where I can set this up in Excel? Thanks.
 

A:Excel view selection

Read other 8 answers
RELEVANCY SCORE 44.8

I have reinstalled Office XP. Problem still persist. I can't view two separate Excel files simultaneously. When I open the second file it replaces the first one. Why? What can I do to view both Excel file windows on the desktop?
Using Windows 2K
[email protected]
 

A:Excel XP can't view 2 windows

Read other 7 answers
RELEVANCY SCORE 44.8

Hello people!

I am trying to do something that I don't know if anyone else might have tried before...I am writing a Macro in Excel that will give a user the list of all the folders present within a selected folder. I have been successful in getting that onto a spreadsheet using the Shell command...

This is important for Project Managers who need to work with a lot of directories for their projects...especially when they want to create a new one for their project taking an old one as a base...the PM would typically add/modify/delete from the existing directory structure.

Now here is what I want:
I want the user to be able to add/modify/delete the directory structure according to his/her needs and specify a location and hit some button - that will create the new directory structure at the new location specified by the user. The problem is that the dump that I get from the Shell command is not very user friendly to add/modify/delete the directories. For example:
User wants the dump of C:\Data and gets the following on a spreadsheet (with the Shell command) -

http://img135.imageshack.us/img135/6644/screenprintiv2.png

where Exchange, n014996 and N212710 are the folders within C:\Data. Temp is the only folder within Exchange. Similarly, the folder n014996 contains 5 sub-folders. There are no sub-folders within N212710.

Here, the user may choose to add a new folder within C:\Data or modify any of the existing folders or even delete. I want the user to be able to do it w... Read more

A:Tree View in Excel

Read other 6 answers
RELEVANCY SCORE 44.8

I recently had to do a system restore and now my .jpg and jpeg files have a bad file icon. They still do open with the windows pic program as I want them to - but only on the admin accout, I usually surf and play and do everything else with a user account, and even if I reset everything under folder options for the file associacions it somehow doesn't apply to the other account.
The funny thing is that windows tells me in the file association menu that I changed the file association's properties and can set them back to standart "photo suite 6" - a program that I uninstalled ages ago ... can I somehow set this back to the normal winxp picture and fax displaying thing?
 

A:File opens with wrong program, bad file icon in explorer view

problem solved...
 

Read other 1 answers
RELEVANCY SCORE 44.8

Thanks for the help I have already received from this friendly forum!

How to force Windows 7 File Explorer to display ALL audio folder content as normal files in detailed view with file name/size/date and without title/artist/album.

A:How to display all audio file folders in detailed file view

Hello Robilong,

If the audio folders all have the Music folder template, then you could use Apply to All Folders to set on these folders the way you like it with details view and have it applied to all "Music" folders.

Hope this helps,
Shawn

Read other 1 answers
RELEVANCY SCORE 44.4

have designed an invoice form in Excel 2010
have made a Drop down box using the "products" worksheet information in the drop down list. The drop down list shows only column 1.

some ITEMS in the "products" worksheet, have the same name (col 1) with different prices in (col 2)
for example:

the following is an example of the "product" list:
col 1 col 2
apple $44
apple $48
apple $50

I would like to view columns 1 and 2 in the drop down list to make the choice of which price to charge

depending which row "apple" is chosen from, the price goes into the amount column on the invoice, with the description showing only "apple"

I wish to only show "apple" in the invoice description area

so ... how to view 2 columns (in the drop down Box) but only make one entry (from col 1) into the invoice?
 

A:Excel Drop down box how to view 2 columns

It sounds like you would need to set up a third column in your sheet to combine the Col1 and Col2 information and then link your drop down to that. Assuming your drop down tool is an activex or forms type rather than "in cell validation" type, you can then fill your invoice with the information from Col1.
See attached.
 

Read other 14 answers
RELEVANCY SCORE 44.4

In previous versions of Windows, I could right click on a file saved on the desktop and send it to the printer. This option is not available.
 
Do I need to change a setting in Windows 8.1, or is this a setting that needs to be changed in printer software??
 
Thanks

A:Print File from Desktop (without opening the file to view)

This is a PDF file. Does it make a difference? Right clicking on a JPEG shows an option to print without opening the file. 

Read other 3 answers
RELEVANCY SCORE 44

I have a workbook containing seven workshhets on tabs and I want to view several simultaneously. I would also like to size each sheet differently. Can anyone help?
 

A:EXCEL - View multiple worksheets simultaneously

Read other 6 answers
RELEVANCY SCORE 44

If I do a print preview I can see columns A & B but on my screen spreadsheet I can not see them. These columns are not hidden, this is verified by the print preview and if I put my curser in C1 and use the left arrow button to move to the left I see the "B1" and "A1" in the little box to the left of the fx area. (if the columns were hidden this would not show)
How can I get column A & B to show on the screen. I have also made sure my view is completely to the left.
 

A:Unable to view Column A & B in excel but not hidden

Is the same behavior displayed on other pc's with the workbook in question?

Regards,
Rollin
 

Read other 1 answers
RELEVANCY SCORE 44

In XP, and previous IE's we'd click on a link to an excel file and it would pop up within IE, so we could quickly view it. I would like this in IE9, does anyone know how to make this happen? I have not had luck searching for a solution to this in Windows 7/IE9 Thanks!

A:Can I view linked excel 2007 files in IE9?

which version of Office do you have..?
can you provide an example where this is happening..??

does this help?
http://office.microsoft.com/en-us/sh...010105476.aspx

Read other 2 answers
RELEVANCY SCORE 44

My excel was fine, then I clicked something by accident and now I can't view any excels
The excels are accessed through google drive and luckily on a second machine the excels works but not on mine

Anything I can check?

Windows 10- version 10074
Thanks
 

A:My excel was fine, then I clecked something and now I can view any excels

Read other 6 answers
RELEVANCY SCORE 44

I really need help! My computer is dying and I need to transfer some documents over to a newer one being loaned to me. They both have Win 98, but the older one has Works 5.0 and the newer one doesn't, of course. I have sent the wss and wps documents to the new computer via the internet, but they won't open. I get the "Open with..." box, but nothing I choose works. There must be a way to open older documents, but I don't know it.
The Works version I have is 5.0. The Excel version in the newer computer is 2000. Can anyone help? I have already browsed the Micorsoft site and they have nothing there that I can see.
 

A:Works ss to excel

You need to save the "wss" files (in Works) as .xls.

Try the "wps" files as .doc ; if that fails, try .rtf.

Rgds,
Andy
 

Read other 1 answers
RELEVANCY SCORE 44

My boss came in this morning with a Microsoft Works file. He used the spreadsheet and when he put the disk into the drive, he wasn't sure how it could be converted over to Microsoft Excel. It gave him a bunch of funny looking signs. Can someone please help me!
 

A:From Works to Excel?

It shouldn't nee to be "converted" per se.

What version of Excel is he using, and what version of Works was it?
Excel 2000 and 2002 will open Works 2.0 files with no probs.

What extension does the new file use? If it is wks, then it should be no problem.
Otherwise, Works: How to Import and Export Works Spreadsheets to Excel 97
 

Read other 1 answers
RELEVANCY SCORE 44

if someone sent me a document made up in EXCEL attached to an e-mail,could i read this EXCEL document with Ms WORKS 4.5,since i do not have EXCEL?
 

A:EXCEL and MS WORKS

You can always go here to get the free viewer if you just need to look at it, http://office.microsoft.com/downloads/2000/xlviewer.aspx
 

Read other 3 answers
RELEVANCY SCORE 44

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help
 

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

Read other 6 answers
RELEVANCY SCORE 44

I have a friend who is suddenly experiencing an issue where they are no longer able to Open an Excel file through their Windows Explorer (e.g. when trying to open a Excel file from within their My Documents folder). After double clicking on the file, Excel opens and acts as if it is opening the file but then proceeds to show just a blank worksheet. The file does not appear to be corrupt since they can then go to File/Open from within Excel, locate the folder and then Open it without a problem.

Any suggestions? Any ideas would be greatly appreciated as to the cause and resolution for this.

Thank you greatly,

Mike
 

A:Excel 2000 - Unable to open Excel file thru Windows Explorer

Check this out: http://www.pcreview.co.uk/forums/thread-1781119.php
 

Read other 1 answers
RELEVANCY SCORE 44

Hello,

I need help to create an Excel macro that would

1. ask users to select x number of rows to be copied from one worksheet of one Excel file
2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

Notes:
the target Excel files are all based on the same template
there is one worksheet in each of the target Excel files

in the target files, the rows should be copied from the first available empty row, going down

Looking forward to your help!

Thanks a lot.
Mzz
 

A:Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Hi, welcome to the board.
Not much info there to get the correct picture.
Sample? Of source and template please
And not to forget, what version of Excel are you and the users using?
 

Read other 1 answers
RELEVANCY SCORE 43.6

i have windows 7 32 bit and ms office 2007!i have a excel file named work.xlsx located in (d:\andi\),andi is my folder and the final path is (d:\andi\work.xlsx).i create a new folder in d:\ named (andi2) and i copy of excel file (d:\andi\work.xlsx) in (d:\andi2\work.xlsx).now i have two identical copies of (work.xlsx) in two different paths.Now i want to send a shortcut of (work.xlsx) in desktop,but i want to modify excel file shortcut that is located in desktop and the changes that i made in shortcut will be reflected in both (d:\andi\work.xlsx) and (d:\andi2\work.xlsx).ONE EXCEL FILE SHORTCUT MODIFY AT THE SAME TIME TWO EXCEL FILES!!! thanks a lot if you help me!
 

A:One excel file shortcut modify at the same time two excel files!!!

so just so's I understand; you want one shortcut to open two files? That ain't going to work.
 

Read other 1 answers
RELEVANCY SCORE 43.6

Hi guys,

Since a day or two I?m having the following issue when I close an excel file (extension xlam).

I write my own addin files and have been using them for many, many years.

I?ve read that this seems to be a bug with Excel 2010 but the strange thing is why now and not before?

The addin is not installed, I run it when I need it, it contains the necessary xlm code with custom ribbons and all the necessary buttons, you name it, it just works as it should.

I have one button that either close the addin or quits Excel altogether

The VBA project?s properties are set to non-visible and password protected.

Now I get the dialog prompt to enter the VBE password. If I enter the password or press cancel, all I get is that Excel has encountered a problem and will shutdown.

OS: Windows 10 64-bit, Office 2010 and everything has been running fine with Windows 01 and before that with Windows 7

VBA Editor window is not maximized (as I read on several posts), and when I remove the password and save it and then reopen the vbe editor does not show up anymore when closing.

If I run the same macro directly, not using the menu button, the same thing happens. It seems like it?s trying to access the VBA properties, but I have not added any code to do that.

Very strange and especially I do not like thing I do not understand, no changes made and I do not address the VBE components in any way.

Any ideas?
P.S. I cannot upload the file but the thing is that it just started, all at on... Read more

Read other answers
RELEVANCY SCORE 43.6

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

A:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

Read other 1 answers
RELEVANCY SCORE 43.6

I am using an ASP.NET 2.0 web application using the Interop assembly pointing to the Microsoft.Excel 12.0 COM to open and write to a spreadsheet.

I have set the permissions for the DCOM to allow NETWORK SERVICE to open the Excel application, but when I try to open the actual file I get Exception from HRESULT: 0x800A03EC.

I have changed the website directory permissions to allow NETWORK SERVICE full access to the folder and I still cannot open the file.

Thoughts?

Read other answers
RELEVANCY SCORE 43.6

I have an Excel Workbook where I try to embed a Word and Excel file (icon). But, I cannot open the file afterwards. However, my colleagues can open it when I sent it to them by email. What could be the problem with my application.

I tried disabling my spyware software and reloading Microsoft Office XP but the problem is still there,

What could be the problem?
Thanks a lot
 

Read other answers
RELEVANCY SCORE 43.6

I have Excel 2002. I copied a table from a web page and pasted it into Excel. All the info went into cells as it should have, but some of the gridlines are gone. Tools --> Otions --> Views has gridlines checked. Changing the gridline color does not bring them back. Turning off the gridlines view option and turning it back on does not bring them back. And not of the cells are outlined in the cell format borders option. Have seen this before but the sheet was unimportant so I did not pursue.

Thanks!
 

A:Excel - gridlines view (not print, not tools options)

Read other 6 answers
RELEVANCY SCORE 43.6

Help. While in Customise in Excel, I accidentally seem to have dragged the View command off the very top list of menus and I cannot figure out how to restore it.

My toplevel list of Menus reads: File Edit Insert Format Tools Data Window Help.

Now, this might sound dopey, but I THINK there used to be a View command there, and it's now gone. (I saw something slipping by out of the corner of my eye when my finger slipped on the mouse). BUT I cannot restore it.

I've tried resetting the Menus and Toolbars to their default settings. Used Tools, Customise, Reset, but that hasn't worked (I just lost all the customised settings I'd made, but I can do those again).

I tried searching for help on the web and found a theoretical fix, but it relies on going into View, Toolbars... and I don't have that View command listed!

Can anyone tell me how to restore it?
 

A:Solved: Excel 2003 - how to restore 'View' to Menu?

have you just tried to do a simple repair of Microsoft office?
 

Read other 3 answers
RELEVANCY SCORE 43.6

Hi

Can anyone help me please?

I've attached normal view and print preview screenies of a document I'm having problems with.

You can see the small embedded Visio diagram but if you go to print preview or try and it print it, the embedded diagram doesnt shows/print

Any ideas?

Pileyrei
 

A:Cant view an embedded Visio diagram in Excel 2003

Have you set the Print Area to encompass the cells that the diagram occupies?

It doesnt look like it, otherwise the blank cells would show even if the Visio drawing didn't?
 

Read other 3 answers
RELEVANCY SCORE 43.6

Hi guys,

I have been using a spreadsheet for work for sometime now without issue. I have several custom views set up, each displaying a certain filter that I have set using the drop down boxes on each column.

Just recently I have found the need to add a new advanced filter. The filter itself works fine but when I try and recall the custom view of this filter is get an error message "some view settings could not be applied".

I have noted that this subject has been covered before and that the solution for most is to make sure that all the sheets in the workbook are unprotected. The problem is, my workbook is already totally unprotected. I have even tried starting a new workbook and running a simple test filter/custom view combo and get the same issue.

Can anyone point me toward an alternative cause for this? Or perhaps there is some sort of protection applied that I don't know about?

Thanks in advance
 

Read other answers
RELEVANCY SCORE 43.6

I have a person who made a spreadsheet in Works but we use Excel. Can they save it as an .xls ? I can open their file but it looks like garbage. Is there any way around this or does everyone have to use Excel ? Pleas help. Thanks !
 

A:Works and Excel Problem

Read other 7 answers